Date expires in 2 years

  • Thread starter Thread starter Catguam
  • Start date Start date
C

Catguam

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.
 
With the date you want to test against in A1

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

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to know formula to make expire in a year. 4
Expiration dates 7
If formula current/expired/blank 3
How do I summarize dates of events to a new worksheet to count ho. 1
Lookup expiration dates by calendar month 4
Excel Formula - Count Dates from another Sheet 8
Formula help 2
Non-Expiring Data Sim Card? 4

Back
Top