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.
|