Date to years

S

Savage

Is there anyway of converting a date to the amount of years. I have
employees years started posted and I want to convert to years worked with the
company.

Thanks

Kevin
 
G

Guest

Hi

If the date is a recognised Excel date, you can simply deduct the date from
today's date and format the result as yy.

Hope this helps.
Andy.
 
P

pinmaster

Hi, try this:

=DATEDIF(A1,TODAY(),"y") # years

you can also use:

"m" - months
"d" - days
"ym" - year months
"yd" - year days

HTH
JG
 
P

Peo Sjoblom

If you only have the starting years and want a rough estimate (calendar
years) you can use

=YEAR(TODAY())-A1

where A1 holds the start year

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top