Excel-Date Calculation Question#1 of 3

  • Thread starter Thread starter Frank
  • Start date Start date
F

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)
 
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.
 
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
 
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
 
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
Click to expand...
 
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
Click to expand...
 
Back
Top