How do I subtract a date from a date for a sum of total years?
If the current date is in A1 and the start date is in B1, then
=year(A1)-year(B1) formatted as general will return the number of years
worked.
--
Gary''s Student
"Paige" wrote:
I am trying to calculate how many years an employee has worked. I have start
date and current date. What is the formula to return years worked?
|