Formula
 

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

Formula
 

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

Formula
 

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