ExcelBanter - Date expires in 2 years

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date expires in 2 years (https://www.excelbanter.com/excel-worksheet-functions/203443-date-expires-2-years.html)

Catguam

Date expires in 2 years

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.

Peo Sjoblom[_2_]

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.

Catguam

Date expires in 2 years

Thank you.

"Peo Sjoblom" wrote:

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.

All times are GMT +1. The time now is 03:52 AM.