View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Anne Troy Anne Troy is offline
external usenet poster
 
Posts: 26
Default training cert expiration times need to be flagged in excel

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.