Formula

K

kmmh

I am working on a spreadsheet that has a column where people will enter in
the date they completed a class, then the next column has a formula in it to
show them when they need to take the class again (Every 2 -3 years). If the
completed column is blank, then I need the due next column blank, as well.
But, if there is a date in the completed column, it will need to calculate
the next date it is due.

Does anyone have any suggestions on how to do this?

Thank you!!
 
D

Dave F

Something like =IF(ISBLANK([completion date column]),"",[completion date + 2
years]) entered in the due date column would do the trick.

Dave
 
G

Gord Dibben

Assume a date is entered in A1

In B1 enter =IF(A1="","",A1 + 730)

730 is 2 years....you choose a number.

Drag.copy the B1 formula down column B as far as you wish.


Gord Dibben MS Excel MVP
 
Top