Log in
x
or
x
x
Register
x

or

unanswered Formula Help: Round to the 1st of the next year after a specific date

More
1 month 3 weeks ago #1946 by lbeans@slwsd.org
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

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun