Need help with a formula

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

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.
 
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
 
Look here:

http://www.cpearson.com/excel/datedif.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
Back
Top