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
Bookmarks