I occasionally want to do something related to a calendar, and I don't like the popped up calendar when double clicking on the Windows' clock. I know there may be similar code out there but decided to build my own simple calendar generator.
Just run this on a blank worksheet.
A 'forced' 5-week month looks like this:
May |
Sun |
Mon |
Tue |
Wed |
Thu |
Fri |
Sat |
Week 18/23 |
31 |
|
|
|
|
1 |
2 |
Week 19 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
Week 20 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
Week 21 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
Week 22 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
while a 6-week month looks like this:
May |
Sun |
Mon |
Tue |
Wed |
Thu |
Fri |
Sat |
Week 18 |
|
|
|
|
|
1 |
2 |
Week 19 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
Week 20 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
Week 21 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
Week 22 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
Week 23 |
31 |
|
|
|
|
|
|
Bookmarks