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


           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?


    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.

    :!:Forum Rules

  • This?


    Yes, Thank you so much