Help on date..

[senjuti.sarkar]

Friends now one more thing I like do in my excel sheet.

cell H10= any date about to put..

cell K5=H10+7

What I want is, when I put a date to cell H10, cell K5 will show the next 7th day's date.

It is done, but, when I left the cell H10 blank, the K5 is showing "7-JAN-00", I want that cell K5 blank is H10 is blank.

Can you please help me...?

Thanks in advance

Senjuti

[DGagnon]

=if(h10>0,h10+7,"")

[senjuti.sarkar]

Thanks dear friend,

It worked..