Excel-Date Calculation Question#1 of 3

[Frank]

Hi I am trying to calculate Years of Service with the
dates given below. Is there a formula to take "Start
Date" and "Job End Date" and get Years of Service? If yes
what is it? thx, Frank

Start Date Job End Date Years of Service
08/30/1982 10/31/2003 ? (Answer 21.0)

 

[Eva Shanley]

Hello,
Try this...
=DATEDIF(A1,B1,"Y"); this assumes your start date is in
cell A1 and your end date is in cell B1. The "Y" gives
the number of complete years in the period; could also
be "M" or "D" for months or days.

 

[Jim]

=DATEDIF(EarlierDate,LaterDate,"y")

 

[Rick S]

Just try (date2 - date1)/365. i.e. if 8/30/1982 is cell
a1 and 10/31/2003 is cell b1. In c1 do: =(b1-a1)/365.
Set format to number 2 dec.

Hope this helps
R

 

[Guest]

Eva that formula worked great. Is there any way to carry
it out 2 decimal places. My example below should come up
with 21.14 years not just 21. thx, Frank

 

[John Drummond]

YEARFRAC(A1,A2)

Eva that formula worked great. Is there any way to carry
it out 2 decimal places. My example below should come up
with 21.14 years not just 21. thx, Frank

 

[John Drummond]

Look at the YEARFRAC function.

Eva that formula worked great. Is there any way to carry
it out 2 decimal places. My example below should come up
with 21.14 years not just 21. thx, Frank