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?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!