how do I do this: today minus hire date equals how many years mo.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a spreadsheet that calculates how many
years/months/days someone has worked with the company. When I use
=today()-the hire date , it adds a month onto it and the days are wrong.
 
=DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months,
" & DATEDIF(A1,TODAY(),"md") & " days"

be careful of the wrapping
 
Back
Top