Home |
Search |
Today's Posts |
#1
|
|||
|
|||
difference between two dates in years, months and days.
I want to calculate number of years, months and days between a hire date and
today's date. |
#2
|
|||
|
|||
Try this with the hire date in C4
=DATEDIF(C4,TODAY(),"y") & " y " & DATEDIF(C4,TODAY(),"ym") & " m " & DATEDIF(C4,TODAY(),"md") & " d" -- Regards Ron de Bruin http://www.rondebruin.nl "ruby" wrote in message ... I want to calculate number of years, months and days between a hire date and today's date. |
#3
|
|||
|
|||
Look at the advice offered at this link
http://www.cpearson.com/excel/datedif.htm "ruby" wrote: I want to calculate number of years, months and days between a hire date and today's date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85. | Excel Worksheet Functions | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Difference between two dates in months with decimals | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions | |||
Difference between two dates in months with decimals | Excel Worksheet Functions |