date + 23 days

[Rick]

I have to calulate a date + 23 days.(=A1+23) I can do it
but when I copy the formula down it shows me a value and I
don't want to see the value if the date in A column is
blank. When copied down I get 1/23 answer. Please help

 

[Paul B]

Rick, here is one way

=IF(ISBLANK(A1),"",A1+23)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Govind]

Hi,

Use

=IF(A1<>"",A1+23,"") and copy down.

Format the cells in the date format.

Regards

Govind.