Hi there,
I am working out my company's Years of service awards, I have a report on thousands of Years of service calculations supplied to me, I then worked out how man days they had as breaks in service to determine there actual years of service.
So now my issue is calculating this, Attached is my sample sheet Years of Service is in years I then have the breaks in service calculated in Days I converted this in the next column to Years Months Days now need a formula to calculate the years minus the breaks in Years Months Days format.
Bookmarks