DATEDIF function in excel
 

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?

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?

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?

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?