Forum Discussion
MarkSanDiego
Mar 08, 2022Copper Contributor
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...
- 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.
MMCCOY
Apr 06, 2022Copper Contributor
Thanks Mark! I couldn't remember this fix. It has been years since I needed it.