Please help! date showing as 1900/01/00

T

toodles779

Joined
Jul 18, 2018
Messages
1
Reaction score
0
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
 
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

:user:
 
Back
Top