DATEDIF function in excel
You are close:
=(current date - hire date)/365.25
Just switch the dates around and wrap them in ()s and you are set. Copy the
formula down to all your records.
--
Regards,
PJ
Please rate this post using the vote buttons if it was helpful.
"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?
|