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

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

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" wrote in message
...
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 ..

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