Performing calculations on only cells with data

[Nat]

I have a worksheet which has a column called File date and another column
called response due which I would like to calculate based on the File Date
column. The request is to add 30 days to the File Date column. I looked up
the followin function in an excle book
=DATE(YEAR(D3),MONTH(D3)+1,DAY(D3))

My question is how do I only bring back values only for the cells with data.
As it stands now, there are blank cells and it brings back 1/31/1900 anyhow.
I think I need to add an If argument but am not sure how to format if I do.

I tried the following
=ISTEXT(D3),DATE(YEAR(D3),MONTH(D3)+1,DAY(D3),"") but that got an argument
error.

Thanks in advance ..

 

[Toppers]

Try:

=IF(ISBLANK(D3),"",DATE(YEAR(D3),MONTH(D3)+1,DAY(D3)))

HTH

 

[Ronald Dodge]

Use an if then else type function such as the following:

=IF(D3="","",DATE(YEAR(D3),MONTH(D3)+1,DAY(D3))

Note, your DATE function was attempting to use one too many arguments. For
conditional things like this, you have to use the IF, THEN, ELSE function to
get what you are looking for when writing formula.

Ronald R. Dodge, Jr.
Master MOUS 2000

 

[Nat]

Thanks that was perfect. I knew it was something similar. Thanks a bunch.

Nat