Calculating Weeknumber

[Colby]

I have a spreadsheet where I get a forecast in monthly numbers, and I want to blow it out to weekly buckets using VBA.

I have the Month, and the number of weeks per month. How could I compute the weeknumber based on these two items? I am at a loss.

Thanks!

 

[VoG]

This should help http://www.cpearson.com/Excel/WeekNumbers.aspx

 

[Colby]

Thank you for the resource VoG, but I don't know that it helps. All the functions on the pearson site are at a day level of granularity from what I can tell.

I am only going to have information on the Month # and the # of weeks in that month. I'll keep at it and post whatever I come up with.