hi
you can also use conditional formatintg.
on the menu bar...
Formatconditional format...
formaula is...=IF(DATE(YEAR(B2)+1,MONTH(B2),DAY(B2))TODAY( ),1,0)...
pick your cell color.

then in 1 year from the data of last refresher, the cell will turn color
alerting you that a refresher is due.

Regards
FSt1

"PK" wrote:

I am responsible for peoples training therefore I am required to monitor when
refreshment courses are due. For this I would like to create an excel dtabase
in to which I can place a date in one cell and then when a set periods has
passed I am informed that a refresher is due.
for example.
E3 may contain the date for which an individual first attended a course
i.e. 21st Oct 2007.I the would then like cell F3 to show 'Refresher Due' once
12 months had passed. In the mean time I would like cell F3 to be blanc. I
realise that I may have to have a Cell, A1 for example with 'todays date' in
to give F3 a reference.can this be done?
Thank you for your help.
--
pk