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.
