Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 03 December 2019
  0 Replies
  2.4K Visits
0
Votes
Undo
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
There are no replies made for this post yet.