Getting the date of 1/00/1900 when a cell is blank...

[Jon C via OfficeKB.com]

I'm getting an entry for 1/00/1900 in a cell that should be blank while using
a formula for distributing a date from one page to another that corresponds
with its month (example: 1/03/05 shows up in only Jan 05's page when using
the formula =IF(MONTH('Main info'!F10)=MONTH('Jan 05'!$B$2),'Main info'!F10,
""). All the other months beyond January show up blank as the formula says.
Is there anything I can do to have the 1/00/1900 show up as a blank cell like
the others?

Sincerely,

Jon

 

[Jerry W. Lewis]

An Excel formula must return something. =A1 will return 0 if A1 is
blank. If you format 0 as a date, it will display as 1/0/1900, and
Month(0)=1 (January).

Use
=IF(ISNUMBER('Main info'!F10),your_formula,"")

Since this is not causing Excel to crash, the General Questions or
Worksheet Functions newsgroups would have been more appropriate, and
would have gotten you a much faster reply.

Jerry

 

[Jon C via OfficeKB.com]

Thanks for the reply will look there in the future.

An Excel formula must return something. =A1 will return 0 if A1 is
blank. If you format 0 as a date, it will display as 1/0/1900, and
Month(0)=1 (January).

Use
=IF(ISNUMBER('Main info'!F10),your_formula,"")

Since this is not causing Excel to crash, the General Questions or
Worksheet Functions newsgroups would have been more appropriate, and
would have gotten you a much faster reply.

Jerry

I'm getting an entry for 1/00/1900 in a cell that should be blank while using
a formula for distributing a date from one page to another that corresponds

[quoted text clipped - 7 lines]

Jon