View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Date expires in 2 years

With the date you want to test against in A1

=IF(DATEDIF(A1,TODAY(),"y")=2, "train","Alright for now")

--


Regards,


Peo Sjoblom

"Catguam" wrote in message
...
I am looking for a formula that would mark the cell as "EXPIRED" if the
date
is 2 years or more.

My scenario is if a person is trained I need to be notified if the date
trained is 2 years or more because it means they need to be retrained.