Excel 2010 I would like a formula to calculate Years of Service as of the Current Year

[vickiecroft]

I have a spreadsheet with Employee Information. Column J is Hire Date (formatted as a Date mm/dd/yy). I would like column K to be listed as Years of Service.

I am using Windows 7 & Excel 2010.

 

[blaow]

=YEAR(TODAY())-YEAR(J2)

Put that formula in column K2 and drag it down.

 

[barry houdini]

How do you deal with partial years? If you just want the number of full years try using DATEDIF, e.g. in K2 copied down

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

so if J2 is 1/1/2008 that will currently give you 6 but 4/4/2008 will give you 5

 

[blaow]

good point houdini. Your formula is better.