Hello again,

I intend producing a spreadsheet (Excel 2003) which holds training course details and the dates each employee must complete the refresher.

What I want to do is construct a formula which will show a "FLAG" which is 30 days before the date in the cell being looked at. For example. a training course is completed on 28 January 2014. The refresher for the course is annual and the next renewal would be 27 January 2015.

I want the flag to pop up, saying "REFRESHER DUE" in the same column/row (F7), 30 days before the due date of 27 January 2015. In order to further highlight the flag the cell showing the answer will be in red text.



What I have in mind is something like =IF(E7<=(E7-30),REFRESHER DUE,"") where Cell E7 has the date of the review.

For the life of me I cant get this to work.

I have attached a spreadsheet showing what I have in mind.

Grateful for any help.

Attached Files

Training Record DRAFT.xls (33.5 KB, 9 views)