Please help! date showing as 1900/01/00

[toodles779]

Hi everyone -

I'm running a simple forumla that says =IF(I5<>"";I5;31/12/2018). So if there is a date already in the cell, pull that date, if there isn't, put 31/12/2018. When there is a date, it pulls this nicely, but where there's a blank I get 1900/01/00. I've formatted the cells to 'date' and I've also looked to see if the transition box is checked under options, which it isn't. Can anyone help me please?

Thank you!

Tania

 

[muckshifter]

MrGoogle says ...

"When you reference an empty cell in a formula, Excel treats it as zero ... that includes simple linking formulas from one workbook to another ... and zero in date format comes out as 00/01/1900"
or 1900/01/00 depending on your English.

Mr Google also says, use a formula like:

=IF(ISNUMBER(SheetA!CellX),SheetA!CellX,"")


HTH

 

[Becky]

Good solution @muckshifter