Forum Discussion
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...
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.
No worries now....I found the solution. It is, custom format with: mm/dd/yyyy;"1/0/1900";;@
But thank you anyway!
But thank you anyway!
MarkSanDiego how did you sort this? im in a similar situation 2 years later.. lol
