Hi All

I need a little bit of help please, if you don'r mind.

I am using a formula in E2 to calculate 1 year and 1 day from the date entered in C2:

=DATE(YEAR(C2)+1,MONTH(C2),DAY(C2)+1)

My problem is I need to combine an if(isblank function to the function above so that when there is no date in the subsequent cells in column C nothing appears in the corresponding cell in column E all be it the formula will be there.

Hope this makes sense

Any help would be appreciated

Teuchter