Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Due dates
Hi..
I would like to know who of the employees continued 5 years at work relying on his/her starting date. Thanx. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Due dates
Assuming the start date is in cell A1,
=(TODAY()-A1)/365=5 Will return TRUE when greater than or equal to 5 years, FALSE when less. "Firas" wrote: Hi.. I would like to know who of the employees continued 5 years at work relying on his/her starting date. Thanx. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Due dates
=IF(DATE(YEAR(A1)-5,MONTH(A1),Day(A1))<=TODAY(),"Yes","No")
-- HTH RP (remove nothere from the email address if mailing direct) "Firas" wrote in message ... Hi.. I would like to know who of the employees continued 5 years at work relying on his/her starting date. Thanx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |