IF and EDATE

[enwoznick]

I am using the following formula to calculate a due date and leave blank if nothing is entered. I want to also add a a rule so if "NA" is entered in the reference cell (J5), then "NA" is also shows up in the current cell.

=IF(J5,EDATE(J5,6),"")

Any help would be appreciated. Thanks!

Elise

[Roel Jongman]

try
=IF(J5,EDATE(J5,6),J5)

then it should show blank if J5 is blank and show NA if J5 is NA and the due date if any other value is entered

[enwoznick]

Thanks! That works but if the cell is blank it returns a date of "1/0/1900". Is there a way to just have it stay blank?

[Roel Jongman]

Easiest way I can think of is to put a conditional formatting rule on the cell with the formula that when cell is blank format is set to text that should show a blank cell instead of the strange date

[63falcondude]

Try this:

=IF(J5="NA","NA",IF(J5="","",EDATE(J5,6)))

[ron2k_1]

How about

Please Login or Register  to view this content.

This checks if J5 is either zero, blank or non-numerical