formula to figure time of service

[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!

 

[Charlie]

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

 

[Guest]

OOPS
Forgot the closing ) in A3 and A4

Sorry
Charlie O'Neill