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!!

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

Dave
--
Brevity is the soul of wit.


"kmmh" wrote:

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!!

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

On Wed, 20 Sep 2006 11:26:02 -0700, kmmh wrote:

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!!