| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Send mail when deadline expires | Excel Discussion (Misc queries) | |||
| To delete a row automatically ocne a closing date expires. | Excel Discussion (Misc queries) | |||
| How do I subtract a date from a date for a sum of total years? | Excel Discussion (Misc queries) | |||
| How to set up alarm for cell has entry as date when it expires? | Excel Worksheet Functions | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
Linear Mode
