Hi all,
Not sure how to go about these formulas I'm working on with the data I have been given.
I have this formula in all my C column and when I don't get a correct date result it instead to be blank will show the date 1/0/1900. The problem is that I am using this column C to create a pivot and the column C is the Pivot's date, however I need to get rid of this year 1900
=IF(COUNTIF($B$1:B2,B2)=1,A2,0)