Thread: Date to years
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Date to years

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)


"Savage" wrote in message
...
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