Greetings,

I’m trying to distribute from a monthly projected amount of let says “Twinkies” by day. Based on last year performance which is represented by % (percentages) by day of the week (Sun., Mon., Tue., Etc.). Is it possible to input a total amount per month example 1,500 boxes of Twinkies and according to the percentage of the day of the week if would distribute it accordingly?

I kind of stumped with variables how many Mondays in a month etc, how t avoids get an incomplete result like in the case 1,498 or 1503 Twinkie boxes. Any help would be deeply appreciated.