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?

  • FaKest

    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,"")

    Yes, Thank you so much