Hello,
I am trying to create a formula that calculates the number of years from a specific date to today. I would like for the years of service to populate on the first of the month even if the employee was not hired until later on in a specific month.
For example, today is 4/12/23 and my employee Dan Johnson was hired on 4/18/2002. If I run the formula today(or any day of the month), I would like the formula to calculate he has 21 years of service as long as it is in the same month of his hire date even though he technically would not hit 21 years of service until 4/18/2023.
I am trying to create a formula that calculates the number of years from a specific date to today. I would like for the years of service to populate on the first of the month even if the employee was not hired until later on in a specific month.
For example, today is 4/12/23 and my employee Dan Johnson was hired on 4/18/2002. If I run the formula today(or any day of the month), I would like the formula to calculate he has 21 years of service as long as it is in the same month of his hire date even though he technically would not hit 21 years of service until 4/18/2023.
Date Calculator.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Name | Hire Date | Number of Years of Service | ||
2 | Smith, Sam | 4/1/1999 | |||
3 | Johnson, Dan | 4/18/2002 | |||
4 | Obama, Shelley | 4/24/2009 | |||
5 | Madden, John | 4/9/2012 | |||
Sheet1 |