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
|