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 |