0
Undo
Votes
I need formula assistance.
If an employees hire date is 5/1/2019 they do not become eligible for a benefit until after 1 year 5/1/2020 but the benefit does not actually start until January 1, 2021. I am looking for a formula to calculate the benefit effective date which is always the 1st of January after their 1 year anniversary. I have found rounding to the next month formulas but nothing to round to the 1st of the next year.Any help would be appreciated.
Hire Date 1 Year Date Effective Date
5/1/2019 5/1/2020 1/1/2021
If an employees hire date is 5/1/2019 they do not become eligible for a benefit until after 1 year 5/1/2020 but the benefit does not actually start until January 1, 2021. I am looking for a formula to calculate the benefit effective date which is always the 1st of January after their 1 year anniversary. I have found rounding to the next month formulas but nothing to round to the 1st of the next year.Any help would be appreciated.
Hire Date 1 Year Date Effective Date
5/1/2019 5/1/2020 1/1/2021
There are no replies made for this post yet.