bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 701
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I have situation where I have new people who are paid monthly draws for the first three months of their employment.
What I would like to do is to have a formula that will populate one cell with EOM dates to remind me when to include them in payroll.
I just missed a couple of draws last month because I thought the rep's first payment was to be in Oct. I realized after the fact it was supposed to start in Sept.
So I thought, if it was possible, is to have a formula that I could use that would populate the first 3 pay dates. The result in the formula cell should be the first EOM date after their hire month.
Is this possible?
I know that I could have these month end dates populates over 3 rows in an array but I would rather have them in one cell if possible.
Example:
Criteria (Cell B3)
State date: 8/20/2020
Result (all dates are one cell):
9/30/2020, 10/31/2020,, 11/30/2020
Thank you in Advance,
Michael
What I would like to do is to have a formula that will populate one cell with EOM dates to remind me when to include them in payroll.
I just missed a couple of draws last month because I thought the rep's first payment was to be in Oct. I realized after the fact it was supposed to start in Sept.
So I thought, if it was possible, is to have a formula that I could use that would populate the first 3 pay dates. The result in the formula cell should be the first EOM date after their hire month.
Is this possible?
I know that I could have these month end dates populates over 3 rows in an array but I would rather have them in one cell if possible.
Example:
Criteria (Cell B3)
State date: 8/20/2020
Result (all dates are one cell):
9/30/2020, 10/31/2020,, 11/30/2020
Thank you in Advance,
Michael