How to get rid of 1/0/1900 in IF formula?

• 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)

any ideas how I could get rid of it or maybe replace for the word Blank?

• FaKestApr 23rd 2020

Changed the title of the thread from “How to get hid of 1/0/1900 on IF formula?” to “How to get rid of 1/0/1900 in IF formula?”.
• This?

=IF(COUNTIF(\$B\$1:B2,B2)=1,A2,"")

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

• This?

=IF(COUNTIF(\$B\$1:B2,B2)=1,A2,"")

Yes, Thank you so much

• No probs.

Ali

Enthusiastic self-taught user of MS Excel who's always learning!
If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.