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
|