Hi Sir/ Madam,
I have Monthly budget which I would like to split to Weekly. Can you please assist me with formula.
Input Data:
Output .. The monthly Revenue needs to be populated in below Weekly Revenue column .....
*Week No is calculated considering 1st Jan is WED. (Formula Used: WEEKNUM(A2,13))
Regards,
Shan
I have Monthly budget which I would like to split to Weekly. Can you please assist me with formula.
Input Data:
Month | Revenue |
Jan | 50,000,000 |
Feb | 42,000,000 |
Mar | 46,000,000 |
Apr | 60,000,000 |
May | 48,000,000 |
Jun | 45,000,000 |
Jul | 58,000,000 |
Aug | 62,000,000 |
Sep | 43,000,000 |
Oct | 45,000,000 |
Nov | 47,000,000 |
Dec | 58,000,000 |
Output .. The monthly Revenue needs to be populated in below Weekly Revenue column .....
*Week No is calculated considering 1st Jan is WED. (Formula Used: WEEKNUM(A2,13))
Start of Week | Week No | Weekly Revenue |
1-Jan-20 | 1 | |
8-Jan-20 | 2 | |
15-Jan-20 | 3 | |
22-Jan-20 | 4 | |
29-Jan-20 | 5 | |
5-Feb-20 | 6 | |
12-Feb-20 | 7 | |
19-Feb-20 | 8 | |
26-Feb-20 | 9 | |
4-Mar-20 | 10 | |
11-Mar-20 | 11 | |
18-Mar-20 | 12 | |
25-Mar-20 | 13 | |
1-Apr-20 | 14 | |
8-Apr-20 | 15 | |
15-Apr-20 | 16 | |
22-Apr-20 | 17 | |
29-Apr-20 | 18 | |
6-May-20 | 19 | |
13-May-20 | 20 | |
20-May-20 | 21 | |
27-May-20 | 22 | |
3-Jun-20 | 23 | |
10-Jun-20 | 24 | |
17-Jun-20 | 25 | |
24-Jun-20 | 26 | |
1-Jul-20 | 27 | |
8-Jul-20 | 28 | |
15-Jul-20 | 29 | |
22-Jul-20 | 30 | |
29-Jul-20 | 31 | |
5-Aug-20 | 32 | |
12-Aug-20 | 33 | |
19-Aug-20 | 34 | |
26-Aug-20 | 35 | |
2-Sep-20 | 36 | |
9-Sep-20 | 37 | |
16-Sep-20 | 38 | |
23-Sep-20 | 39 | |
30-Sep-20 | 40 | |
7-Oct-20 | 41 | |
14-Oct-20 | 42 | |
21-Oct-20 | 43 | |
28-Oct-20 | 44 | |
4-Nov-20 | 45 | |
11-Nov-20 | 46 | |
18-Nov-20 | 47 | |
25-Nov-20 | 48 | |
2-Dec-20 | 49 | |
9-Dec-20 | 50 | |
16-Dec-20 | 51 | |
23-Dec-20 | 52 | |
30-Dec-20 | 53 |
Regards,
Shan