Please help! date showing as 1900/01/00


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
 
Ad

Advertisements

muckshifter

I'm not weird, I'm a limited edition.
Moderator
Joined
Mar 5, 2002
Messages
25,641
Reaction score
1,148
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:
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top