Hi,

I was asked to create a spreadsheet to keep track of training for employees.
The employees have to complete a training session every six months. The
training dates are not the same.

For example:

- Employee 1 completed training on Jan 1, 2009 and his next training session
is due on July 1, 2009.

- Employee 2 completed training on Feb 1, 2009 and his next training session
is due on August 1, 2009.

I envision three columns:

1) Employee Name
2) Date Training Completed
3) Next Training Date

Columns 1 and 2 would be inputted manually, and the next training date would
automatically be inputted. For example, I would input that John Doe completed
his training on Jan 1, 2009 and then the next training date, July 1, 2009,
would automatically be inputted.

There are actually three different training sessions that have different
"due dates" . I'm just using 6 months as an easy example. I'm assuming that
the formula used allows me to pick and choose the period of time that the
next "training session" is "due".

The second item I would like to see on this spreadsheet is some kind of
reminder 30 days before the next training date. It could either be a pop-up,
the employees name could appear in another cell with the next training date,
or the respective employees row/cells can be highlighted to indicate that
their training is due in 30 days.

I hope this doesn't sound too complicated. I am using Excel 2001.

I am not a beginner when it comes to Excel, but I am when it comes to
formulas so I would really appreciate if you could simplify your answers for
me.

Thank you in advance for your help.