DATEDIF function in excel

[Rosa]

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?

 

[PJFry]

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.

 

[Mike H]

and using datedif

=DATEDIF(A1,TODAY(),"y")

and with months

=DATEDIF(A1,TODAY(),"y")&" Years "&DATEDIF(A1,TODAY(),"ym")&" Months"

Mike

 

[Jacob Skaria]

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

 

[exceladvance]

Difference of Dates

There is no need to install Analysis Toolpack. DATEDIF is the function which can help you do the same, for some good reason Microsoft don't talk much about this function not even in their help.

You can visit the following link which I believe will help you understand this wonderful function.

http://www.slideshare.net/nsurani/excel-datediff-function