Spreadsheet: 137245d1327011050-allocating-expenses-using-a-4-week-5-week-accounting-calendar-4-week-5-week
Sheet: Sheet1

Store # | 2012-01-12 00:00:00 | 2012-02-12 00:00:00 | 2012-03-12 00:00:00 | 2012-04-12 00:00:00 | 2012-05-12 00:00:00 | 2012-06-12 00:00:00 | 2012-07-12 00:00:00 | 2012-08-12 00:00:00 | 2012-09-12 00:00:00 | 2012-10-12 00:00:00 | 2012-11-12 00:00:00 | 2012-12-12 00:00:00
101 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 142.8571428571429
102 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 142.8571428571429
103 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 142.8571428571429
104 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 142.8571428571429
105 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 142.8571428571429
106 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 142.8571428571429
107 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 10.98901098901099 | 10.98901098901099 | 13.73626373626374 | 142.8571428571429
 |  |  |  |  |  |  |  |  |  |  |  |  | 1000
7 | # of Stores
 |  |  |  |  |  |  |  |  |  |  |  | Total Amount of Invoiceto Allocate | 1000
 |  |  |  |  |  |  |  |  |  |  |  | Weeks in the Year | 52
 |  |  |  |  |  |  |  |  |  |  |  | Total Amount per Week | 19.23076923076923
 |  |  |  |  |  |  |  |  |  |  |  | 4 Week Month Total for each store | 76.92307692307692
 |  |  |  |  |  |  |  |  |  |  |  | 5 Week Month Total for each store | 96.15384615384615
This schedule is on the basis of regular months having 4 weeks and quarter end months having 5 weeks, thus still keeping it at 52 weeks for the year, such as:
January | 4
February | 4
March | 5
April | 4 |  |  |  | What I'm trying to do
May | 4 |  |  |  | Assume that store 102 opens in May and store 103 closes in June.  I'm want to adjust the totals so that the cells highlighted are zero, but every other cell is consistant with the amounts, meaning May expense for Store #102 should be the same as Store #106 May expense.
June | 5
July | 4
August | 4
September | 5
October | 4
November | 4
December | 5
 | 52