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

Nat

"Toppers" wrote:

Try:

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

HTH

"Nat" wrote:

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 ..