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.

Please Login or Register  to view this content.
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