Forum Discussion

MarkSanDiego's avatar
MarkSanDiego
Copper Contributor
Mar 08, 2022

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...
  • Riny_van_Eekelen's avatar
    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.

Resources