Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm doing some analysis regarding length of employees service but can't find
any thread relating to a formula that may help do this specifically. Example Employee A started working on 01/01/2000 and resigned on 01/02/2009 The start date is in e.g. cell A1 and the resignation date is in e.g. cell A2 Can someone give me a formula that will basically deducted one date from the other date and tell me how many years and months they worked for us? e.g. the answer I would like to see is 9 (for the years) and 1 (1 for the month). If you can, please be very simplistic with your explanation as I don't know excel very well and tend to stumble around with any formulas I do use. Thanks in advance -- Tassy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summarizing Dates into Months and Years | Excel Discussion (Misc queries) | |||
problem of calculating years months and days | Excel Discussion (Misc queries) | |||
FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
calculating years/months with YEARFRAC? | Excel Worksheet Functions | |||
Dates - Months & Years | Excel Worksheet Functions |