Date of Service Caculation

[marya]

I have two dates and need to caculate lenght of employment service ie.

12-1-00 to 9-10-04 .... I'd like it to caculate like 1.22 years of service.

Do you know the formulas?

 

[tmischler]

this is a very rough version but very simple:

write your start date and your end / current date
go to cells / format / number and change to number format

subtract one cell from the other and divide by 365.25

 

[marya]

Thanks TMISCHLER. I using this for a turnover report and to project turnover costs... anyone have a exact way of caculating?

 

[Scott Huish]

How does 12-1-00 to 9-10-04 calculate to 1.22?

 

[tmischler]

I kind of ignored that bit!

 

[marya]

If I knew what it caculated too, I would have put that in... but since I'm trying to figure that out I threw a number out there for the format I was looking for....

 

[tbird]

I assume that you want an answer in decimal years such as your example 1.22? Check out Chip Pearsons site for handling date calculations http://www.cpearson.com/excel/datedif.htm)

 

[carabale]

Try this: =YEARFRAC(A1,B1)

 

[Scott Huish]

carabale's answer will require that you have the Analysis Toolpak installed.