How to find usual credit card amounts by each day of the month?

[Alex20850]

[having trouble uploading sample data]
The credit card period runs from the 6th of month 1 and ends on the 5th of month 2. Then, the payment is due on the 2nd of Month 3.
Then, the 6th of month 2 runs to the 5th of month 3.
etc.
I am trying to find the typical credit card amount for each day of a month.
For example, today is the 20th and if the credit card amount has reached $1,800 is above or below normal.

 

[JamesCanale]

This isn't too compact...

Mr Excel Playground 3.xlsm
	A	B	C	D	E	F	G
1		Charges	Day of Month	Running Total		Day	Average Balance
2	1/6/2021	$ 116	6	$ 116		6	$ 87.41
3	1/7/2021	$ -	7	$ 116		7	$ 130.12
4	1/8/2021	$ 72	8	$ 187		8	$ 139.08
5	1/9/2021	$ 67	9	$ 254		9	$ 179.80
6	1/10/2021	$ -	10	$ 254		10	$ 209.43
7	1/11/2021	$ -	11	$ 254		11	$ 239.73
8	1/12/2021	$ -	12	$ 254		12	$ 258.62
9	1/13/2021	$ -	13	$ 254		13	$ 335.04
10	1/14/2021	$ -	14	$ 254		14	$ 335.19
11	1/15/2021	$ -	15	$ 254		15	$ 386.74
12	1/16/2021	$ 197	16	$ 451		16	$ 444.02
13	1/17/2021	$ -	17	$ 451		17	$ 506.58
14	1/18/2021	$ -	18	$ 451		18	$ 564.19
15	1/19/2021	$ -	19	$ 451		19	$ 572.86
16	1/20/2021	$ -	20	$ 451		20	$ 624.34
17	1/21/2021	$ -	21	$ 451		21	$ 699.63
18	1/22/2021	$ 62	22	$ 513		22	$ 757.50
19	1/23/2021	$ -	23	$ 513		23	$ 785.09
20	1/24/2021	$ -	24	$ 513		24	$ 808.24
21	1/25/2021	$ -	25	$ 513		25	$ 816.05
22	1/26/2021	$ -	26	$ 513		26	$ 845.21
23	1/27/2021	$ -	27	$ 513		27	$ 862.49
24	1/28/2021	$ 42	28	$ 555		28	$ 934.98
25	1/29/2021	$ 7	29	$ 562		29	$ 915.68
26	1/30/2021	$ -	30	$ 562		30	$ 976.60
27	1/31/2021	$ -	31	$ 562		31	$ 1,026.43
28	2/1/2021	$ -	1	$ 562		1	$ 1,022.33
29	2/2/2021	$ -	2	$ 562		2	$ 1,069.09
30	2/3/2021	$ -	3	$ 562		3	$ 1,104.71
31	2/4/2021	$ -	4	$ 562		4	$ 1,128.28
32	2/5/2021	$ 198	5	$ 760		5	$ 1,195.39
33	2/6/2021	$ -	6	$ -
34	2/7/2021	$ 113	7	$ 113
35	2/8/2021	$ -	8	$ 113
36	2/9/2021	$ -	9	$ 113
37	2/10/2021	$ 53	10	$ 166
38	2/11/2021	$ 120	11	$ 286
39	2/12/2021	$ -	12	$ 286
40	2/13/2021	$ 23	13	$ 309
41	2/14/2021	$ -	14	$ 309
42	2/15/2021	$ 181	15	$ 489
43	2/16/2021	$ -	16	$ 489
44	2/17/2021	$ 104	17	$ 593
45	2/18/2021	$ 151	18	$ 744
46	2/19/2021	$ -	19	$ 744
47	2/20/2021	$ 132	20	$ 876
48	2/21/2021	$ 182	21	$ 1,058
Sheet15

Cell Formulas
Range	Formula
C2:C48	C2	=DAY(A2)
D2:D48	D2	=IF(DAY(A2)=6,B2,B2+D1)
G2:G32	G2	=AVERAGEIFS($D$2:$D$220,$C$2:$C$220,F2)
A3:A48	A3	=A2+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A220	Expression	=IF(DAY(A2)=6,TRUE,FALSE)	text	NO

 

[Alex20850]

Thanks