Benefits eligibility is first of month coincident or next following 60 days. Example - if hired 5/3/23, the 60th day worked is 7/1/23 so that would be the eligibility date. But if hired 5/4/23, the 60th day worked is 7/2/23 so the eligibility date would roll to 8/1, Can someone help with a formula for this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
First of month coincident or next following x number of days formula
- Thread starter kristylee
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,616
- Office Version
- 365
- Platform
- Windows
What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Maybe
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)
Maybe
| Fluff.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | ||||
| 2 | 03/05/2023 | 01/07/2023 | ||
| 3 | 04/05/2023 | 01/08/2023 | ||
Numbers | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2:B3 | B2 | =IF(DAY(A2+59)>1,EOMONTH(A2+59,0)+1,A2+59) |
Upvote
0
