I don't understand the last bit but with the DES in a1 try this

=DATEDIF(A1,TODAY(),"y")&" Years "&DATEDIF(A1,TODAY(),"yM")&" Months
"&DATEDIF(A1,TODAY(),"md")&" Days"

Mike

"JJ" wrote:

Need to calculate the number of years an employee has worked. I'd like to use
the Today() function as an absolute reference in the formula. I also want to
divide the difference by the number of days in a year.
--
jj