Hi All,
I want to make the partial week split between month as below example. And you may see the highlighted color which split between month.
So is there any formula can split it like this?
I want to make the partial week split between month as below example. And you may see the highlighted color which split between month.
So is there any formula can split it like this?
| Book3 | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Month | 01-Aug-22 | |||
| 2 | |||||
| 3 | Week No. | Week Start | Week End | ||
| 4 | 31 | 01-Aug-22 | 07-Aug-22 | ||
| 5 | 32 | 08-Aug-22 | 14-Aug-22 | ||
| 6 | 33 | 15-Aug-22 | 21-Aug-22 | ||
| 7 | 34 | 22-Aug-22 | 28-Aug-22 | ||
| 8 | 35 | 29-Aug-22 | 31-Aug-22 | ||
| 9 | 35 | 01-Sep-22 | 04-Sep-22 | ||
| 10 | 36 | 05-Sep-22 | 11-Sep-22 | ||
| 11 | 37 | 12-Sep-22 | 18-Sep-22 | ||
| 12 | 38 | 19-Sep-22 | 25-Sep-22 | ||
| 13 | 39 | 26-Sep-22 | 30-Sep-22 | ||
| 14 | 39 | 01-Oct-22 | 02-Oct-22 | ||
| 15 | 40 | 03-Oct-22 | 09-Oct-22 | ||
| 16 | 41 | 10-Oct-22 | 16-Oct-22 | ||
| 17 | 42 | 17-Oct-22 | 23-Oct-22 | ||
| 18 | 43 | 24-Oct-22 | 30-Oct-22 | ||
| 19 | 44 | 31-Oct-22 | 31-Oct-22 | ||
| 20 | 44 | 01-Nov-22 | 06-Nov-22 | ||
| 21 | 45 | 07-Nov-22 | 13-Nov-22 | ||
| 22 | 46 | 14-Nov-22 | 20-Nov-22 | ||
Sheet1 | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B4 | B4 | =B1 |
| A4:A22 | A4 | =ISOWEEKNUM(B4) |
