Years of Service

[Southland]

Can someone help me with a formula to determine an employee's years of service as a real time running total between hire date and current date?

 

[Asbestos_Jen]

This will give you years as a real number. You could also use "today()" in place of $C$2 in the same formula.

2023-12-20.xlsx
	B	C	D
2	Today:	21-12-23
3
4	Employee	Hire date	Years of Service
5	Jason Hamilton	1-May-95	28.64
6	Kristy Deschenes	4-Jun-04	19.55
7	Kim Jobin	22-Aug-08	15.33
8	Meghan Beaudry	7-Mar-13	10.79
9	Jean-Francois Arsenault	21-Aug-17	6.33
10	Jean-Guy Gray	14-Dec-18	5.02
11	Lyn Nguyen	11-Apr-21	2.69
12	Jonathan Evans	31-Aug-21	2.31
13	Nathalie Small	4-Aug-13	10.38
14	Shawna Donaldson	4-Sep-02	21.30
15	Cindy McCormick	13-Sep-15	8.27
16	Elise Pike	6-Mar-15	8.79
17	Pascale Marsh	14-Jun-16	7.52
18	Duncan Gaudet	3-Jan-02	21.97
19	Mary Legare	5-Dec-23	0.04
Yearsofservice

Cell Formulas
Range	Formula
C2	C2	=TODAY()
D5:D19	D5	=YEARFRAC(C5,$C$2)