|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 22nd, 2008, 08:11 PM
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
September 22nd, 2008, 08:37 PM
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 news  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
September 22nd, 2008, 09:01 PM
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 news 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
