Question: what is the formula in excel to calculate years of service?
Answer: In cell A3 write the following formula = DATEDIF(A1,A2,"y"). This measures length of service in years and rounds it down. You can also use this to calcuate age by putting date of birth in cell A1. It's a great formula as it calculates age or length of service and rounds it down all in one go.