Home > OS >  Exclude 01-00-1900 result from TEXT formula in Excel
Exclude 01-00-1900 result from TEXT formula in Excel

Time:12-20

I am using the TEXT function to convert field date_Field_ABC values like so: =TEXT([@[date_Field_ABC]], "mm-dd-yyyy") which works fine, but how do I extend the same TEXT formula so that the default values of 01-00-1900 do not show at all (from when date_Field_ABC is empty)? Thank you

CodePudding user response:

Try something like:

=TEXT([@[date_Field_ABC]], "mm-dd-yyyy;;;")

In my comment I included the conditional [>0] but it isn't necessary and should be omitted.

The format string is interpreted as:

  • return a formatted date for a positive value
  • return nothing for a negative value, zero value, or text value
  • Related