formula to figure time of service

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I work for a large healthcare facility that is trying to
track in Excel the time of service their employees have
worked for them. They are wanting to have one column list
the employee's start date with the company. They are
wanting the next column to show the number of years,
months, and days from the start date to today's date. Is
their a formula that would easily calculate this number
for them? Thanks!
 
Try

Assuming A1 is the start date.

in A2 enter =DATEDIF(A1,TODAY(),"Y")
in A3 enter =DATEDIF(A1,TODAY(),"YM"
in A4 enter =DATEDIF(A1,TODAY(),"MD"

or to enter it all in one cell

=DATEDIF(A1,TODAY(),"Y")&" Year "&DATEDIF(A1,TODAY(),"YM")
&" Months "&DATEDIF(A1,TODAY(),"MD")&" Days"

Charlie O'Neill
 
Back
Top