Thread: how do I do this: today minus hire date equals how many years mo.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how do I do this: today minus hire date equals how many years mo.
=DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months,
" & DATEDIF(A1,TODAY(),"md") & " days"

be careful of the wrapping
--
Gary''s Student - gsnu200750


"btaylor1990" wrote:

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.
Reply With QuoteReply With Quote