Forum Discussion

Copper Contributor

Mar 08, 2022

Solved

Hiding "1/0/1900" when representing empty date formatted cells

I have two sheets in a workbook. Call them sheet "1" and "2". A particular cell in sheet 1 references (pulls from) a particular cell in sheet 1. Both cells in both sheets are "date" formatted. Wh...

excel

Riny_van_Eekelen
Mar 08, 2022
MarkSanDiego Perhaps a formula like this will work better:
=IF(ISBLANK(Sheet2!A1),"",Sheet2!A1)
It will first look is there is something in A1 on Sheet2. If it's empty return an empty string, else return what's in Sheet2!A1.

MarkSanDiego

Copper Contributor

Mar 09, 2022

No worries now....I found the solution. It is, custom format with: mm/dd/yyyy;"1/0/1900";;@
But thank you anyway!

NikolinoDE

Gold Contributor

Mar 09, 2022

I'm glad you came to a solution.
Thanks for the feedback.