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