Exclude 01-00-1900 result from TEXT formula in Excel

Question

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

Answer 1

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