Issues converting monthly to weekly goals due to overlapping months

Hello,

I've searched other posts and have tried solutions that people have suggested, but they aren't working for me. My goal is to take my monthly goal and break it down into weeks. As you know weeks overlap with months and that is where I am having difficulty. The simple days in month/monthly goal and taking that number * 7 doesn't give me my monthly goal.

The report goes Sunday - Saturday

For instance the monthly goal is 847 and 31 days in the month. 847/31 = 27/day. 27*7(days in the week) = 191/week. January essentially has 5 weeks so how do I formulate that extra week?

I'm trying to upload my spreadsheet but the system isn't letting me, but here is a screenshot if that helps at all.

I appreciate any assistance.

Capture.JPG

January really has 4 weeks and 3 days, rather than the 5 weeks you claim. Perhaps this is what is causing you the problems.

Pete

That isn't the issue, I'm having the same problem with every other month as well. Thank you though for the suggestion.