DATEDIF function in excel
and using datedif
=DATEDIF(A1,TODAY(),"y")
and with months
=DATEDIF(A1,TODAY(),"y")&" Years "&DATEDIF(A1,TODAY(),"ym")&" Months"
Mike
"Rosa" wrote:
i have to find out how many years employee has been working on the job. using
current date - hire date/365. result have to be in years? who knows the right
function, so i can get the answers for all employees at one time?
|