First day of month falls on a Monday VBA issue

Hey all,

This month I came across a problem.
I have a workbook with code in that pulls data from a previous workbook (last month), in order to rank things.
My issue is that when the first of the month falls on a Monday, my 5 week basis (starting on Monday) falls through.
What I mean by that is that November's 5 weeks include the few days from October that fell in the first week, however, with December starting on a Monday, it doesn't include any of the previous month.

So to cut to the chase, I need some code that in effect says:

If the next Month starts on a Monday then do this...

Else do this...


Thanks in advance for your help.

The only thing I need is the IF statement to determine whether the next month will begin on a Monday.
The rest I can input by myself, but thank you anyway.

That's fair enough.

Please Login or Register  to view this content.

Thank you, I'll give that a whirl!