Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel Average dates help 0
Counting # of Formulas in a column with formulas and entered data 1
conditional formatting for Column with Dates 2
Comparison of columns using Conditional Formatting 3
Alert in Microsoft Excel 2
Help with calulating Null fields 3
count number of dates in range 2

Back
Top