Having trouble calendarizing a utility bill across multiple months. Is there a quicker method than what I've done so far?

[helnuma2k]

I have a worksheet that lists out 90 different invoices by usage type (call, text, email), period date & period end, and the total usage for that period. I am responsible for filling out the appropriate usage amount for each month of 2016 and the first month of Jan 2017 (columns O-S).

Fiver.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1		Morgan Mobile
2
3							Month Ending
4		Invoice_#	Usage_Type	Total_Usage	Period_Start	Period_End	Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16	Dec-16	Jan-17
5		Invoice_1	Calls	34,553	1/3/16	1/30/16	34,553.00
6		Invoice_2	Texts	2,519	1/5/16	2/5/16	2,146.96	372.04	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
7		Invoice_3	Emails	52,740	1/9/16	2/9/16	39,076.32	13,663.68	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
8		Invoice_4	Texts	40,072	1/15/16	2/20/16	18,606.49	21,465.51	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
9		Invoice_5	Texts	41,381	1/18/16	2/21/16	17,121.90	24,259.10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
10		Invoice_6	Emails	3,417	1/21/16	2/24/16	1,121.43	2,295.57	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
11		Invoice_7	Texts	3,460	1/24/16	2/23/16
12		Invoice_8	Calls	43,506	1/26/16	2/29/16
13		Invoice_9	Emails	39,119	1/31/16	3/5/16
14		Invoice_10	Texts	55,658	2/2/16	3/2/16
15		Invoice_11	Calls	2,737	2/7/16	3/11/16
16		Invoice_12	Emails	42,376	2/13/16	3/14/16
17		Invoice_13	Texts	3,138	2/17/16	3/17/16
18		Invoice_14	Calls	1,558	2/23/16	3/29/16
19		Invoice_15	Texts	51,149	2/27/16	4/2/16
20		Invoice_16	Emails	2,193	3/3/16	4/5/16
21		Invoice_17	Emails	3,128	3/8/16	4/9/16
22		Invoice_18	Texts	1,425	3/11/16	4/10/16
23		Invoice_19	Emails	29,022	3/16/16	4/14/16
24		Invoice_20	Calls	39,616	3/19/16	4/21/16
25		Invoice_21	Calls	5,852	3/23/16	4/21/16
26		Invoice_22	Emails	9,615	3/28/16	4/29/16
27		Invoice_23	Calls	40,159	3/31/16	5/2/16
28		Invoice_24	Texts	6,457	4/3/16	5/6/16
29		Invoice_25	Calls	10,223	4/8/16	5/11/16
30		Invoice_26	Texts	9,493	4/10/16	5/16/16
31		Invoice_27	Emails	3,966	4/15/16	5/20/16
32		Invoice_28	Texts	41,225	4/17/16	5/23/16
33		Invoice_29	Texts	40,652	4/22/16	5/25/16
34		Invoice_30	Emails	29,174	4/28/16	5/30/16
35		Invoice_31	Texts	49,083	5/4/16	6/7/16
36		Invoice_32	Calls	13,760	5/10/16	6/14/16
37		Invoice_33	Emails	22,461	5/14/16	6/17/16
38		Invoice_34	Texts	15,941	5/16/16	6/18/16
39		Invoice_35	Calls	25,160	5/19/16	6/17/16
40		Invoice_36	Emails	15,542	5/24/16	6/29/16
41		Invoice_37	Calls	12,413	5/30/16	6/29/16
42		Invoice_38	Texts	13,709	6/5/16	7/9/16
43		Invoice_39	Emails	10,890	6/10/16	7/14/16
44		Invoice_40	Texts	17,946	6/12/16	7/17/16
45		Invoice_41	Texts	44,056	6/14/16	7/20/16
46		Invoice_42	Emails	28,089	6/17/16	7/19/16
47		Invoice_43	Texts	42,243	6/23/16	7/26/16
48		Invoice_44	Calls	23,573	6/26/16	7/31/16
49		Invoice_45	Emails	15,031	7/2/16	8/4/16
50		Invoice_46	Texts	9,846	7/8/16	8/6/16
51		Invoice_47	Calls	26,890	7/10/16	8/10/16
52		Invoice_48	Texts	30,372	7/15/16	8/14/16
53		Invoice_49	Emails	5,959	7/19/16	8/22/16
54		Invoice_50	Texts	43,870	7/23/16	8/27/16
55		Invoice_51	Texts	1,923	7/28/16	9/1/16
56		Invoice_52	Emails	29,936	8/1/16	9/3/16
57		Invoice_53	Texts	22,821	8/3/16	9/6/16
58		Invoice_54	Calls	42,773	8/9/16	9/8/16
59		Invoice_55	Emails	44,917	8/11/16	9/14/16
60		Invoice_56	Texts	42,235	8/16/16	9/16/16
61		Invoice_57	Calls	7,196	8/19/16	9/20/16
62		Invoice_58	Emails	38,844	8/21/16	9/21/16
63		Invoice_59	Texts	44,911	8/26/16	9/28/16
64		Invoice_60	Calls	49,936	8/29/16	9/28/16
65		Invoice_61	Texts	32,138	8/31/16	10/4/16
66		Invoice_62	Emails	17,183	9/6/16	10/7/16
67		Invoice_63	Emails	2,492	9/11/16	10/13/16
68		Invoice_64	Texts	39,019	9/16/16	10/22/16
69		Invoice_65	Emails	41,300	9/20/16	10/20/16
70		Invoice_66	Calls	4,666	9/22/16	10/28/16
71		Invoice_67	Calls	5,642	9/26/16	10/27/16
72		Invoice_68	Emails	45,172	9/30/16	10/29/16
73		Invoice_69	Calls	49,376	10/2/16	11/3/16
74		Invoice_70	Texts	21,138	10/6/16	11/10/16
75		Invoice_71	Calls	25,145	10/11/16	11/14/16
76		Invoice_72	Texts	26,191	10/13/16	11/17/16
77		Invoice_73	Emails	38,278	10/19/16	11/20/16
78		Invoice_74	Texts	43,728	10/24/16	11/27/16
79		Invoice_75	Texts	17,043	10/28/16	11/28/16
80		Invoice_76	Emails	24,826	10/30/16	11/30/16
81		Invoice_77	Texts	23,819	11/3/16	12/5/16
82		Invoice_78	Calls	35,191	11/5/16	12/7/16
83		Invoice_79	Emails	12,766	11/10/16	12/12/16
84		Invoice_80	Texts	43,287	11/12/16	12/12/16
85		Invoice_81	Calls	49,101	11/17/16	12/17/16
86		Invoice_82	Emails	49,363	11/20/16	12/20/16
87		Invoice_83	Texts	11,788	11/26/16	1/1/17
88		Invoice_84	Calls	22,649	11/28/16	12/31/16
89		Invoice_85	Texts	31,223	12/2/16	12/31/16
90		Invoice_86	Emails	34,649	12/4/16	1/4/17
91		Invoice_87	Emails	45,264	12/6/16	1/11/17
92		Invoice_88	Texts	9,967	12/8/16	1/10/17
93		Invoice_89	Emails	13,625	12/11/16	1/15/17
94		Invoice_90	Calls	13,827	12/14/16	1/19/17
Part1_Calendarized_Usage

Cell Formulas
Range	Formula
G5	G5	=D5
G6	G6	=SUM(Part1_Usage_Curves!$E$101:$E$748)/SUM(Part1_Usage_Curves!$E$101:$E$868)*$D6
H6	H6	=SUM(Part1_Usage_Curves!$E$749:$E$868)/SUM(Part1_Usage_Curves!$E$101:$E$868)*$D6
G7	G7	=SUM(Part1_Usage_Curves!$F$197:$F$748)/SUM(Part1_Usage_Curves!$F$197:$F$964)*$D7
H7	H7	=SUM(Part1_Usage_Curves!$F$749:$F$964)/SUM(Part1_Usage_Curves!$F$197:$F$964)*$D7
G8	G8	=SUM(Part1_Usage_Curves!$E$341:$E$748)/SUM(Part1_Usage_Curves!$E$341:$E$1228)*$D8
H8	H8	=SUM(Part1_Usage_Curves!$E$749:$E$1228)/SUM(Part1_Usage_Curves!$E$341:$E$1228)*$D8
G9	G9	=SUM(Part1_Usage_Curves!$E$413:$E$748)/SUM(Part1_Usage_Curves!$E$413:$E$1252)*$D9
H9	H9	=SUM(Part1_Usage_Curves!$E$749:$E$1252)/SUM(Part1_Usage_Curves!$E$413:$E$1252)*$D9
G10	G10	=SUM(Part1_Usage_Curves!$F$485:$F$748)/SUM(Part1_Usage_Curves!$F$485:$F$1324)*$D10
H10	H10	=SUM(Part1_Usage_Curves!$F$749:$F$1324)/SUM(Part1_Usage_Curves!$F$485:$F$1324)*$D10
B5:B94	B5	="Invoice_"&ROW($A5)-ROW($A$4)

I'm also given a second worksheet 'Part1_Usage_Curves' which lists out the actual usage for each hour of each day (and sorted by usage type) from 1/1/16 to 1/31/17. Preview:

Fiver.xlsx
	A	B	C	D	E	F
1		Usage_Curves
2
3				Calls	Texts	Emails
4		Date	Hour	Usage_Curve_1	Usage_Curve_2	Usage_Curve_3
5		1/1/16	1	2.28	42.65	10.39
6		1/1/16	2	2.25	41.90	10.25
7		1/1/16	3	2.23	40.37	10.13
8		1/1/16	4	2.31	42.84	10.56
9		1/1/16	5	2.30	42.98	10.52
10		1/1/16	6	2.36	43.93	10.80
11		1/1/16	7	2.36	46.13	10.80
12		1/1/16	8	2.49	46.92	11.46
13		1/1/16	9	2.54	49.62	11.70
14		1/1/16	10	2.84	52.30	13.18
15		1/1/16	11	2.96	53.05	13.79
16		1/1/16	12	2.91	52.75	13.57
17		1/1/16	13	2.86	50.78	13.32
18		1/1/16	14	2.69	49.03	12.47
19		1/1/16	15	2.81	48.82	13.03
20		1/1/16	16	2.65	52.52	12.24
21		1/1/16	17	2.78	53.52	12.91
22		1/1/16	18	2.98	55.43	13.88
23		1/1/16	19	3.06	52.86	14.29
24		1/1/16	20	2.96	55.01	13.78
25		1/1/16	21	3.01	53.66	14.06
26		1/1/16	22	2.89	52.28	13.46
27		1/1/16	23	2.77	47.77	12.83
28		1/1/16	24	2.65	45.91	12.26
29		1/2/16	1	2.58	46.05	11.89
30		1/2/16	2	2.58	46.24	11.88
31		1/2/16	3	2.55	45.37	11.76
32		1/2/16	4	2.66	47.16	12.32
33		1/2/16	5	2.77	48.52	12.84
34		1/2/16	6	2.85	50.87	13.26
35		1/2/16	7	2.94	54.56	13.68
36		1/2/16	8	2.97	55.25	13.83
37		1/2/16	9	3.10	55.96	14.48
38		1/2/16	10	3.01	54.14	14.03
39		1/2/16	11	3.05	54.01	14.27
40		1/2/16	12	2.95	53.03	13.77
41		1/2/16	13	2.86	50.78	13.32
42		1/2/16	14	2.69	49.03	12.47
43		1/2/16	15	2.53	48.38	11.67
44		1/2/16	16	2.50	48.30	11.51
45		1/2/16	17	2.61	48.58	12.03
46		1/2/16	18	2.83	52.19	13.16
47		1/2/16	19	2.95	51.97	13.74
48		1/2/16	20	2.85	52.49	13.25
49		1/2/16	21	2.81	51.53	13.07
50		1/2/16	22	2.77	50.94	12.86
51		1/2/16	23	2.63	46.70	12.16
52		1/2/16	24	2.56	45.19	11.78
53		1/3/16	1	2.54	45.62	11.70
54		1/3/16	2	2.54	45.70	11.68
55		1/3/16	3	2.55	45.37	11.76
56		1/3/16	4	2.66	47.16	12.32
57		1/3/16	5	2.82	49.03	13.10
58		1/3/16	6	2.79	50.42	12.96
59		1/3/16	7	2.99	54.96	13.97
60		1/3/16	8	2.91	54.21	13.56
61		1/3/16	9	3.05	56.82	14.25
62		1/3/16	10	3.13	57.14	14.65
63		1/3/16	11	3.10	54.50	14.51
64		1/3/16	12	3.00	53.31	13.98
65		1/3/16	13	2.83	50.66	13.13
66		1/3/16	14	2.63	48.88	12.16
67		1/3/16	15	2.50	47.94	11.51
68		1/3/16	16	2.41	47.49	11.03
69		1/3/16	17	2.42	47.90	11.10
70		1/3/16	18	2.69	50.98	12.44
71		1/3/16	19	2.78	51.07	12.91
72		1/3/16	20	2.92	54.46	13.60
73		1/3/16	21	3.01	53.66	14.06
74		1/3/16	22	2.93	52.73	13.66
75		1/3/16	23	2.81	48.12	13.05
76		1/3/16	24	2.70	46.26	12.49
77		1/4/16	1	2.71	48.48	12.53
78		1/4/16	2	2.71	48.38	12.54
79		1/4/16	3	2.68	48.33	12.42
80		1/4/16	4	2.65	48.15	12.24
81		1/4/16	5	2.80	51.17	13.02
82		1/4/16	6	2.95	53.93	13.75
83		1/4/16	7	3.41	62.42	16.07
84		1/4/16	8	3.75	68.19	17.77
85		1/4/16	9	3.76	70.46	17.78
86		1/4/16	10	4.06	74.18	19.28
87		1/4/16	11	4.15	74.47	19.73
88		1/4/16	12	4.11	72.72	19.56
89		1/4/16	13	4.04	71.85	19.21
90		1/4/16	14	4.01	71.92	19.04
91		1/4/16	15	3.86	69.56	18.28
92		1/4/16	16	3.90	68.56	18.48
93		1/4/16	17	3.98	68.57	18.92
94		1/4/16	18	4.09	69.66	19.47
95		1/4/16	19	4.06	68.57	19.30
96		1/4/16	20	3.85	66.79	18.26
97		1/4/16	21	3.73	65.68	17.64
98		1/4/16	22	3.55	62.30	16.74
99		1/4/16	23	3.39	58.92	15.94
100		1/4/16	24	3.38	57.22	15.89
101		1/5/16	1	3.38	56.07	15.91
102		1/5/16	2	3.43	56.22	16.15
103		1/5/16	3	3.46	56.94	16.29
104		1/5/16	4	3.58	58.88	16.92
105		1/5/16	5	3.63	60.31	17.13
106		1/5/16	6	3.86	64.75	18.32
107		1/5/16	7	4.33	70.85	20.66
108		1/5/16	8	4.59	75.34	21.97
109		1/5/16	9	4.59	78.45	21.93
110		1/5/16	10	4.75	80.47	22.75
111		1/5/16	11	4.75	80.14	22.74
112		1/5/16	12	4.68	78.43	22.38
113		1/5/16	13	4.50	76.57	21.52
114		1/5/16	14	4.32	74.89	20.58
115		1/5/16	15	4.11	71.92	19.56
116		1/5/16	16	4.08	70.40	19.40
117		1/5/16	17	4.03	69.02	19.14
118		1/5/16	18	4.09	69.66	19.47
119		1/5/16	19	4.06	68.57	19.30
120		1/5/16	20	3.85	66.79	18.26
121		1/5/16	21	3.73	65.68	17.64
122		1/5/16	22	3.50	61.69	16.49
123		1/5/16	23	3.30	57.68	15.48
124		1/5/16	24	3.20	55.43	15.00
125		1/6/16	1	3.14	53.36	14.71
126		1/6/16	2	3.23	54.13	15.15
127		1/6/16	3	3.32	55.32	15.58
128		1/6/16	4	3.34	56.06	15.69
129		1/6/16	5	3.38	57.62	15.92
130		1/6/16	6	3.57	61.33	16.87
131		1/6/16	7	4.08	68.51	19.38
132		1/6/16	8	4.27	72.96	20.37
133		1/6/16	9	4.28	75.90	20.40
134		1/6/16	10	4.40	77.33	21.01
135		1/6/16	11	4.45	77.30	21.24
136		1/6/16	12	4.32	74.80	20.59
137		1/6/16	13	4.20	73.42	19.98
138		1/6/16	14	3.96	71.43	18.78
139		1/6/16	15	3.86	69.56	18.28
140		1/6/16	16	3.76	67.19	17.79
141		1/6/16	17	3.73	65.86	17.63
142		1/6/16	18	3.80	66.49	17.98
143		1/6/16	19	3.66	64.74	17.32
144		1/6/16	20	3.58	63.32	16.90
145		1/6/16	21	3.38	60.57	15.88
146		1/6/16	22	3.10	56.77	14.51
147		1/6/16	23	2.92	52.71	13.62
148		1/6/16	24	2.77	49.48	12.84
149		1/7/16	1	2.71	48.48	12.53
150		1/7/16	2	2.71	48.38	12.54
151		1/7/16	3	2.75	48.86	12.74
152		1/7/16	4	2.70	48.71	12.48
153		1/7/16	5	2.77	50.64	12.87
154		1/7/16	6	2.87	53.36	13.37
155		1/7/16	7	3.22	58.75	15.10
156		1/7/16	8	3.54	64.20	16.72
157		1/7/16	9	3.62	68.96	17.08
158		1/7/16	10	3.75	70.52	17.75
159		1/7/16	11	3.99	72.18	18.96
160		1/7/16	12	4.00	71.16	18.98
161		1/7/16	13	3.92	70.27	18.59
162		1/7/16	14	3.88	69.44	18.39
163		1/7/16	15	3.79	68.15	17.93
164		1/7/16	16	3.67	66.27	17.33
165		1/7/16	17	3.64	64.96	17.19
166		1/7/16	18	3.60	63.85	16.99
167		1/7/16	19	3.53	62.01	16.63
168		1/7/16	20	3.33	61.31	15.64
169		1/7/16	21	3.11	58.70	14.56
170		1/7/16	22	2.92	54.93	13.60
171		1/7/16	23	2.69	50.67	12.46
172		1/7/16	24	2.61	48.39	12.06
173		1/8/16	1	2.51	46.31	11.54
174		1/8/16	2	2.46	45.77	11.30
175		1/8/16	3	2.44	43.53	11.18
176		1/8/16	4	2.45	45.88	11.25
177		1/8/16	5	2.49	44.98	11.43
178		1/8/16	6	2.65	50.28	12.24
179		1/8/16	7	3.01	56.54	14.07
180		1/8/16	8	3.34	62.08	15.68
181		1/8/16	9	3.41	66.70	16.04
182		1/8/16	10	3.62	69.11	17.11
183		1/8/16	11	3.81	70.52	18.06
184		1/8/16	12	3.89	70.12	18.44
185		1/8/16	13	3.82	69.22	18.08
186		1/8/16	14	3.82	68.95	18.11
187		1/8/16	15	3.70	67.21	17.48
188		1/8/16	16	3.62	65.81	17.10
189		1/8/16	17	3.64	64.96	17.19
190		1/8/16	18	3.60	64.38	16.99
191		1/8/16	19	3.53	62.01	16.63
192		1/8/16	20	3.33	61.31	15.64
193		1/8/16	21	3.07	58.12	14.34
194		1/8/16	22	2.84	53.93	13.19
195		1/8/16	23	2.55	48.94	11.76
196		1/8/16	24	2.40	45.68	11.02
197		1/9/16	1	2.35	43.50	10.77
198		1/9/16	2	2.29	42.44	10.46
199		1/9/16	3	2.17	39.54	9.86
200		1/9/16	4	2.26	42.07	10.30
201		1/9/16	5	2.25	42.28	10.23
202		1/9/16	6	2.36	43.93	10.80
203		1/9/16	7	2.44	46.81	11.18
204		1/9/16	8	2.44	45.88	11.18
205		1/9/16	9	2.54	49.62	11.70
206		1/9/16	10	2.72	51.07	12.62
207		1/9/16	11	2.91	52.57	13.55
208		1/9/16	12	2.83	52.20	13.16
209		1/9/16	13	2.75	50.44	12.77
210		1/9/16	14	2.69	49.03	12.47
211		1/9/16	15	2.52	48.24	11.62
212		1/9/16	16	2.49	47.98	11.44
213		1/9/16	17	2.46	48.24	11.30
214		1/9/16	18	2.64	50.58	12.20
215		1/9/16	19	2.78	51.07	12.91
216		1/9/16	20	2.68	50.66	12.38
217		1/9/16	21	2.66	49.81	12.29
218		1/9/16	22	2.37	44.45	10.84
219		1/9/16	23	2.31	44.21	10.57
220		1/9/16	24	2.18	41.98	9.88
221		1/10/16	1	2.07	38.53	9.37
222		1/10/16	2	1.93	38.16	8.65
223		1/10/16	3	1.92	37.88	8.62
224		1/10/16	4	1.92	37.20	8.58
225		1/10/16	5	1.90	38.56	8.51
226		1/10/16	6	1.88	40.53	8.39
227		1/10/16	7	1.79	42.46	7.97
228		1/10/16	8	1.87	42.88	8.35
229		1/10/16	9	2.01	45.44	9.05
230		1/10/16	10	2.19	48.41	9.93
231		1/10/16	11	2.33	51.86	10.63
232		1/10/16	12	2.36	49.57	10.80
233		1/10/16	13	2.36	49.84	10.80
234		1/10/16	14	2.34	48.26	10.69
235		1/10/16	15	2.29	47.89	10.47
236		1/10/16	16	2.19	46.74	9.94
237		1/10/16	17	2.26	46.73	10.29
238		1/10/16	18	2.36	48.57	10.78
239		1/10/16	19	2.67	50.48	12.36
240		1/10/16	20	2.75	51.39	12.73
241		1/10/16	21	2.77	51.00	12.87
242		1/10/16	22	2.73	50.49	12.66
243		1/10/16	23	2.68	47.06	12.38
244		1/10/16	24	2.61	45.55	12.04
245		1/11/16	1	2.61	47.40	12.04
246		1/11/16	2	2.66	47.86	12.29
247		1/11/16	3	2.75	48.86	12.74
248		1/11/16	4	2.84	50.41	13.22
249		1/11/16	5	2.95	52.79	13.74
250		1/11/16	6	3.19	56.78	14.95
251		1/11/16	7	3.67	64.76	17.34
252		1/11/16	8	3.90	70.18	18.49
253		1/11/16	9	3.97	73.34	18.87
254		1/11/16	10	4.20	75.53	20.02
255		1/11/16	11	4.20	74.94	19.98
256		1/11/16	12	4.16	73.24	19.82
257		1/11/16	13	4.04	71.85	19.21
258		1/11/16	14	3.90	70.93	18.52
259		1/11/16	15	3.83	68.62	18.15
260		1/11/16	16	3.76	67.19	17.79
261		1/11/16	17	3.73	65.86	17.63
262		1/11/16	18	3.80	66.49	17.98
263		1/11/16	19	3.78	65.84	17.89
264		1/11/16	20	3.63	64.01	17.17
265		1/11/16	21	3.55	63.13	16.76
266		1/11/16	22	3.35	59.84	15.75
267		1/11/16	23	3.20	56.44	15.01
268		1/11/16	24	2.96	53.05	13.82
Part1_Usage_Curves

You can see how invoice # 2 and #3 are filled out already. These were given to me.
I'm supposed to fill out the rest of the table myself, so essentially for Invoices 4 through 90, I need to portion out the total usage amount per each month of the invoice. I don't really have to follow the way it was done in invoices #2 and 3, as long as I get the right answers, but so far that's actually my only lead.

I was able to fill out invoices 4, 5, and 6 this way, but how do I do the same for the rest of the invoices? I really don't want to have to type out the formulas one by one. I tried selecting the formula & dragging it to extend throughout the rest of the worksheet, but the values weren't correct. Is there any other way to automate this or make this a bit easier to accomplish?

I'm a beginner here, so I appreciate you reading this and any help you can offer!

 

[helnuma2k]

This is another method I've been trying.... basically just figuring out the # of days in the period, then creates a new column that lists the usage per day in that period. And then list out the # of days in the first/second/third month of each period so that I can use it to create a simpler formula... Don't know if that makes sense.

CES Excel Exercise_Attempt.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1		Morgan Mobile
2
3													Month Ending
4		Invoice_#	Usage_Type	Total_Usage	Period_Start	Period_End	Days in Period	usage per day	Days in month 1	Days in month 2	Days in month 3		Jan-16	Feb-16	Mar-16	Apr-16	May-16	Jun-16	Jul-16	Aug-16	Sep-16	Oct-16	Nov-16	Dec-16	Jan-17
5		Invoice_1	Calls	34,553	1/3/16	1/30/16	28	1234.0	28				34,553.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
6		Invoice_2	Texts	2,519	1/5/16	2/5/16	32	78.7	27	5			959.36	1,559.64	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
7		Invoice_3	Emails	52,740	1/9/16	2/9/16	32	1648.1	23	9			24,359.94	28,380.06	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
8		Invoice_4	Texts	40,072	1/15/16	2/20/16	37	1083.0	17	20			18,411.46	21,660.54
9		Invoice_5	Texts	41,381	1/18/16	2/21/16	35	1182.3	14	21			16,552.40	24,828.60
10		Invoice_6	Emails	3,417	1/21/16	2/24/16	35	97.6	11	24
11		Invoice_7	Texts	3,460	1/24/16	2/23/16	31	111.6	8	23
12		Invoice_8	Calls	43,506	1/26/16	2/29/16	35	1243.0	6	29
13		Invoice_9	Emails	39,119	1/31/16	3/5/16	35	1117.7	1	29	5
14		Invoice_10	Texts	55,658	2/2/16	3/2/16	30	1855.3	28	2
15		Invoice_11	Calls	2,737	2/7/16	3/11/16	34
16		Invoice_12	Emails	42,376	2/13/16	3/14/16	31
17		Invoice_13	Texts	3,138	2/17/16	3/17/16	30
18		Invoice_14	Calls	1,558	2/23/16	3/29/16	36
19		Invoice_15	Texts	51,149	2/27/16	4/2/16	36
20		Invoice_16	Emails	2,193	3/3/16	4/5/16	34
21		Invoice_17	Emails	3,128	3/8/16	4/9/16	33
22		Invoice_18	Texts	1,425	3/11/16	4/10/16	31
23		Invoice_19	Emails	29,022	3/16/16	4/14/16	30
24		Invoice_20	Calls	39,616	3/19/16	4/21/16	34
25		Invoice_21	Calls	5,852	3/23/16	4/21/16	30
26		Invoice_22	Emails	9,615	3/28/16	4/29/16	33
27		Invoice_23	Calls	40,159	3/31/16	5/2/16	33
28		Invoice_24	Texts	6,457	4/3/16	5/6/16	34
29		Invoice_25	Calls	10,223	4/8/16	5/11/16	34
30		Invoice_26	Texts	9,493	4/10/16	5/16/16	37
31		Invoice_27	Emails	3,966	4/15/16	5/20/16	36
32		Invoice_28	Texts	41,225	4/17/16	5/23/16	37
33		Invoice_29	Texts	40,652	4/22/16	5/25/16	34
34		Invoice_30	Emails	29,174	4/28/16	5/30/16	33
35		Invoice_31	Texts	49,083	5/4/16	6/7/16	35
36		Invoice_32	Calls	13,760	5/10/16	6/14/16	36
37		Invoice_33	Emails	22,461	5/14/16	6/17/16	35
38		Invoice_34	Texts	15,941	5/16/16	6/18/16	34
39		Invoice_35	Calls	25,160	5/19/16	6/17/16	30
40		Invoice_36	Emails	15,542	5/24/16	6/29/16	37
41		Invoice_37	Calls	12,413	5/30/16	6/29/16	31
42		Invoice_38	Texts	13,709	6/5/16	7/9/16	35
43		Invoice_39	Emails	10,890	6/10/16	7/14/16	35
44		Invoice_40	Texts	17,946	6/12/16	7/17/16	36
45		Invoice_41	Texts	44,056	6/14/16	7/20/16	37
46		Invoice_42	Emails	28,089	6/17/16	7/19/16	33
47		Invoice_43	Texts	42,243	6/23/16	7/26/16	34
48		Invoice_44	Calls	23,573	6/26/16	7/31/16	36
49		Invoice_45	Emails	15,031	7/2/16	8/4/16	34
50		Invoice_46	Texts	9,846	7/8/16	8/6/16	30
51		Invoice_47	Calls	26,890	7/10/16	8/10/16	32
52		Invoice_48	Texts	30,372	7/15/16	8/14/16	31
53		Invoice_49	Emails	5,959	7/19/16	8/22/16	35
54		Invoice_50	Texts	43,870	7/23/16	8/27/16	36
55		Invoice_51	Texts	1,923	7/28/16	9/1/16	36
56		Invoice_52	Emails	29,936	8/1/16	9/3/16	34
57		Invoice_53	Texts	22,821	8/3/16	9/6/16	35
58		Invoice_54	Calls	42,773	8/9/16	9/8/16	31
59		Invoice_55	Emails	44,917	8/11/16	9/14/16	35
60		Invoice_56	Texts	42,235	8/16/16	9/16/16	32
61		Invoice_57	Calls	7,196	8/19/16	9/20/16	33
62		Invoice_58	Emails	38,844	8/21/16	9/21/16	32
63		Invoice_59	Texts	44,911	8/26/16	9/28/16	34
64		Invoice_60	Calls	49,936	8/29/16	9/28/16	31
65		Invoice_61	Texts	32,138	8/31/16	10/4/16	35
66		Invoice_62	Emails	17,183	9/6/16	10/7/16	32
67		Invoice_63	Emails	2,492	9/11/16	10/13/16	33
68		Invoice_64	Texts	39,019	9/16/16	10/22/16	37
69		Invoice_65	Emails	41,300	9/20/16	10/20/16	31
70		Invoice_66	Calls	4,666	9/22/16	10/28/16	37
71		Invoice_67	Calls	5,642	9/26/16	10/27/16	32
72		Invoice_68	Emails	45,172	9/30/16	10/29/16	30
73		Invoice_69	Calls	49,376	10/2/16	11/3/16	33
74		Invoice_70	Texts	21,138	10/6/16	11/10/16	36
75		Invoice_71	Calls	25,145	10/11/16	11/14/16	35
76		Invoice_72	Texts	26,191	10/13/16	11/17/16	36
77		Invoice_73	Emails	38,278	10/19/16	11/20/16	33
78		Invoice_74	Texts	43,728	10/24/16	11/27/16	35
79		Invoice_75	Texts	17,043	10/28/16	11/28/16	32
80		Invoice_76	Emails	24,826	10/30/16	11/30/16	32
81		Invoice_77	Texts	23,819	11/3/16	12/5/16	33
82		Invoice_78	Calls	35,191	11/5/16	12/7/16	33
83		Invoice_79	Emails	12,766	11/10/16	12/12/16	33
84		Invoice_80	Texts	43,287	11/12/16	12/12/16	31
85		Invoice_81	Calls	49,101	11/17/16	12/17/16	31
86		Invoice_82	Emails	49,363	11/20/16	12/20/16	31
87		Invoice_83	Texts	11,788	11/26/16	1/1/17	37
88		Invoice_84	Calls	22,649	11/28/16	12/31/16	34
89		Invoice_85	Texts	31,223	12/2/16	12/31/16	30
90		Invoice_86	Emails	34,649	12/4/16	1/4/17	32
91		Invoice_87	Emails	45,264	12/6/16	1/11/17	37
92		Invoice_88	Texts	9,967	12/8/16	1/10/17	34
93		Invoice_89	Emails	13,625	12/11/16	1/15/17	36
94		Invoice_90	Calls	13,827	12/14/16	1/19/17	37
Part1_Calendarized_Usage

Cell Formulas
Range	Formula
M5	M5	=D5
M6	M6	=SUM(Part1_Usage_Curves!$E$461:$E$748)/SUM(Part1_Usage_Curves!$E$461:$E$1228)*$D6
N6	N6	=SUM(Part1_Usage_Curves!E749:E1228)/SUM(Part1_Usage_Curves!$E$461:$E$1228)*$D6
M7	M7	=SUM(Part1_Usage_Curves!$F$437:$F$748)/SUM(Part1_Usage_Curves!$F$437:$F$1132)*$D7
N7	N7	=SUM(Part1_Usage_Curves!$F$749:$F$1132)/SUM(Part1_Usage_Curves!$F$437:$F$1132)*$D7
M8:M9	M8	=I8*H8
N8:N9	N8	=J8*H8
H5:H14	H5	=D5/G5
B5:B94	B5	="Invoice_"&ROW($A5)-ROW($A$4)
G5:G94	G5	=DAYS(F5,E5) + 1