cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 168
Hi,
I am looking to place monthly data into weekly table but some weeks fall into multiple months. Does anyone have a formula that would figure out the % of workdays falling into the first month of the week and second which I could always just subtract from the formula for first month.
As always any help is greatly appreciated.
I am looking to place monthly data into weekly table but some weeks fall into multiple months. Does anyone have a formula that would figure out the % of workdays falling into the first month of the week and second which I could always just subtract from the formula for first month.
As always any help is greatly appreciated.
Week (Day before Weeks starts) | Week number | % first month | % 2nd month |
6/30/21 | 1 | 100% | 0% |
7/7/21 | 2 | 100% | 0% |
7/14/21 | 3 | 100% | 0% |
7/21/21 | 4 | 100% | 0% |
7/28/21 | 5 | 40% | 60% |
8/4/21 | 6 | 100% | 0% |
|