| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate years of service
Does anyone know how to calculate years of service in Excel? (ex. 3 years, 4
months) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate years of service
Look he
http://www.cpearson.com/excel/datedif.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "JenniferD" wrote in message ... Does anyone know how to calculate years of service in Excel? (ex. 3 years, 4 months) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate years of service
Hi
Try this with your starting date in cell A2, You can remove the day section if you don't want it. DATEDIF(A2,TODAY(),"y")&" Years, "&DATEDIF(A2,TODAY(),"ym")&" Months and "&DATEDIF(A2,TODAY(),"md")&" Days" HTH John "JenniferD" wrote in message ... Does anyone know how to calculate years of service in Excel? (ex. 3 years, 4 months) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Years of Service Calculation | Excel Worksheet Functions | |||
| Years of Service Question? | New Users to Excel | |||
| Years of Service Question? | New Users to Excel | |||
| Calculate Years of Service | Excel Worksheet Functions | |||
| Years of service... | New Users to Excel | |||
Hybrid Mode
