Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Excel - calculate months from years in decimal?
I have data for a long list of people. I don't have their actual hire date, only their years of service, in decimal form. For example, 8.92 years of service. These dates are as of August 31, 2013. I need to calculate who will be reaching a service anniversary (9.0) during the months of Oct - Dec. Cannot figure out a formula or two that calculates the 8.92 to 8 years and 11 months and then calculates the one month to reach new year between oct 1 to dec 31. thanks!
2 Answers
- 8 years ago
You can deduce their (approximate) hire date by subtracting [years of service] * 365,25 (365,25 days per year taking into account leap years) from the current date (assuming the date is detected as a numeric value). You might be a day off in some cases (depending on how accurate years of service is).
Once you have the hire date, you can extract the month and compare it with the months you want to check for.
- fathermartin121Lv 68 years ago
A good question
To get the hire date (Hd): =31/8/13-years of service*365.25, formatted as a date.
Establish the 9th anniversary(9an):
=date(year(Hd) 9,month(Hd),day(Hd))
To establish if the ann. occurs in the 4th quarter
=And(9an>1/10/13,9an<31/12/13)
