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

how do I subtract years and then divide
 

try this where cell a15 contains the date hired.

=(today()-a15)/365

--
Don Guillett
SalesAid Software

"crystal" wrote in message
...
I am trying to subtract date hired from today's date and then divide the
difference by 365