Excel Formula 1

[mcaoneill]

Hi,

I need some help this is the formula I have in my spreadsheet, =IF(ISERR(C8+28),"-",C8+28) it works great when cell C8 has a date in it but when there is no date in C8 it returns this value 1/29/1904. What I want to do is if there is no value inputted into C8, cell c11 is blank.

Thank you

Maureen

 

[bluedragon2]

It is giving you 1/29/1904 because in the IF statement, you are checking for an error. An error is not a blank cell. The 1/29/1904 is the result of taking 0+28 and the result is in a date formatted cell. This should work for you:

=IF(ISBLANK(C8),"",C8+28)



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

You can even shorten it to:

=IF(C8,C8+28,"")

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[mcaoneill]

THANK YOU THANK YOU THANK YOU, I have been beating my head against the wall for three days!

Maureen

 

[fneily]

As an aside, notice that your Excel's based date system is based on the January 1, 1904 date. This is the default date for Excel for Mac's. For Excel for Windows, it's January 1, 1900. So if you give this spreadsheet to anyone who has Excel for Windows, they have to reset their system date by clicking on Tools - Options and select the Calculation tab. Or their work will be off by four years.

Neil