I want to calculate number of years, months and days between a hire date and today's date.
R ruby Apr 4, 2005 #1 I want to calculate number of years, months and days between a hire date and today's date.
R Ron de Bruin Apr 4, 2005 #2 Try this with the hire date in C4 =DATEDIF(C4,TODAY(),"y") & " y " & DATEDIF(C4,TODAY(),"ym") & " m " & DATEDIF(C4,TODAY(),"md") & " d"
Try this with the hire date in C4 =DATEDIF(C4,TODAY(),"y") & " y " & DATEDIF(C4,TODAY(),"ym") & " m " & DATEDIF(C4,TODAY(),"md") & " d"
D Duke Carey Apr 4, 2005 #3 Look at the advice offered at this link http://www.cpearson.com/excel/datedif.htm
