Daily Sales Needed Calendar

[ultimateman9]

'Hello Excel Gurus,
I’m Running into a snag here. I’m trying to create a Daily Sales Need Calendar. I’d like the calendar to auto populate daily how many sales needed each day remaining in the month(Based on the actual selling days, we’re closed on Sundays, so since there’s 4 sundays in August we only have 27 total selling days) to hit goal. I’d also like to have a separate calendar on a different tab show what we’re actually pacing to do based on the current daily rate of sales. I’ve attached my actual spread sheet, but listed below is what I’d like the calendar to look like:

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
	8-1	8-2	8-3	8-4	8-5	8-6
	2	2	2	2	2	2

So in this example if we sold 2 phones on Monday and our goal was 12. The formula would auto populate the rest of the week to show we need to sale 2 per day to hit our goal. What formula do I need have it auto populate the rest of the days in the month.
Thanks in Advance