This was okay,but it only flagged one event. I figure the syntax was wrong
somewhere. Thank you:-)
"Anne Troy" wrote:
You may want to simply use a conditional format.
The following example is very close to what you would need to do:
http://www.officearticles.com/excel/...ft_ excel.htm
Your formula would be something like =TODAY()-B2<90
(The "90" being the number of days away, and B2 containing the expiration
date.)
--
~Anne Troy
www.OfficeArticles.com
"Wkdwzdm" wrote:
I have been given the task of creating a spreadsheet of employees which will
flag 3-months before a certification is to expire,i.e., CPR,First
Aid,Firearms, etc.
Do I need to milestone the event or is there something easier. I am a
beginner in using this program, but I am willing to take on the task.