Need help with a formula
 

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

Need help with a formula
 

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

Need help with a formula
 

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JJ" wrote in message ...
| 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

Need help with a formula
 

If you want the number of years, use the DATEDIF function.
http://www.cpearson.com/excel/datedif.aspx
--
David Biddulph

"JJ" wrote in message
...
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

Need help with a formula
 

DES stands for ? Date of employee service??
--
jj


"Mike H" wrote:

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

Need help with a formula
 

sorry Date entered service

"JJ" wrote:

DES stands for ? Date of employee service??
--
jj


"Mike H" wrote:

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