Thread: how do I subtract years and then divide

I am trying to subtract date hired from today's date and then divide the
difference by 365

try this where cell a15 contains the date hired.

=(today()-a15)/365

--
Don Guillett
SalesAid Software
donaldb@281.com
"crystal" <crystal@discussions.microsoft.com> wrote in message
news:4B1CE85E-BDEF-4446-81AE-F26DB49E6115@microsoft.com...
> I am trying to subtract date hired from today's date and then divide the
> difference by 365
>