bobletcs123
New Member
- Joined
- Jan 31, 2019
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Hi There,
Working on warranties for products and need to determine if it should start the beginning of that month, or beginning of next month.
We consider the 1st-15th would be that month, 16th to EOM would be Next month:
So...
8/17/18 = 9/1/18
8/14/18 = 8/1/18
8/7/18 = 8/1/18
9/7/18 = 9/1/18 etc
What would be the best way to go about a formula for this?
Thx
Working on warranties for products and need to determine if it should start the beginning of that month, or beginning of next month.
We consider the 1st-15th would be that month, 16th to EOM would be Next month:
So...
8/17/18 = 9/1/18
8/14/18 = 8/1/18
8/7/18 = 8/1/18
9/7/18 = 9/1/18 etc
What would be the best way to go about a formula for this?
Thx