DATEDIF function in excel
Use DATEDIF(startdate,TODAY(),"y")
Change the last argument as below
m Months
d Days
y Years
ym Months Excluding Years
yd Days Excluding Years
md Days Excluding Years And Months
If this post helps click Yes
---------------
Jacob Skaria
"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?
|