Distribute Amount Based on month days between two dates

[Sufiyan97]

I have below data now I want to distribute amount in column F based on start and end date to particular month based on their days

So for example
in first two dates 27 days of July, 31 days of August and 16 days of September and allocate amount based on number of days of a particular month

Links Tuition 22-23.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								2022								2023
2	District/Parent	Student	Duration			Amount		May	June	July	August	September	October	November	December	January	February	March	April	May	June	July	August	September	October
3							Expected	932.43	1070.57	552.55
4
5	Murray, Lisa	Murray, Jake	Start	End		187.50
6	Stamford	Charly, Peter	7/5/2022	9/17/2022	74	2555.55
7	Darien P.S.	Johns, Judah	6/29/2022	9/23/2022	86	10591.27
8	Norwalk P.S.	Botens Daniel	12/1/2022	3/10/2023	99	22700.00
9	Leonard Santorelli	Bates, Sienna	11/21/2022	1/13/2023	53	14750.00
10	Darien P.S.	Herne, Anabel "Tobi"	12/5/2022	1/20/2023	46	15250.00
11	Merrill, John	Merrill, Poppy	12/5/2022	1/6/2023	32	8000.00
12	Stamford P.S.	Academic Support for ESS/BGC	12/5/2022	1/20/2023	46	26735.00
13	Norwalk P.S.	Sullivan Jennifer	12/5/2022	1/20/2023	46	5900.00
14	Darien P.S.	Steinkraus Griffin	1/3/2023	4/7/2023	94	28375.00
15	Stamford P.S.	Reicin, Tina	12/16/2022	12/22/2023	371	1260.00
16	Greenwich P.S.	Ginste, Elsa	1/3/2023	3/31/2023	87	22700.00
17	VanWyk, Mark	VanWyk, Beckett	1/3/2023	4/7/2023	94	28375.00
18	Lamendola, Kristin	Fallon, Kyle	12/27/2022	12/30/2022	3	910.00
19	Kornstein, Andrew	Kornstein, Lleyton	1/1/2023	3/4/2023	62	14750.00
20	Blanchard, Robert	Blanchard, Henry	1/9/2023	1/24/2023	15	2800.00
21	Greenwich P.S.	Casey, Thalia	1/9/2023	2/24/2023	46	11800.00
22	Edwards, John	Edwards, Hayley	1/6/2023	2/24/2023	49	11800.00
23	Yahong, Chen	Li, Leon	2/1/2023	4/21/2023	79	23050.00
24	Prescott, Finnian	Prescott, Claire	1/23/2023	4/21/2023	88	5675.00
25	Sherman, Scott	Sherman, Matt	1/23/2023	4/28/2023	95	28875.00
26	Brockman, Rhonda	Brockman, Jack	1/23/2023	5/5/2023	102	23200.00
27	Darien P.S.	Herne, Anabel "Tobi"	1/23/2023	3/10/2023	46	5900.00
28	Mottola, Thomas	Mottola, Sakae	1/26/2023	3/24/2023	57	15250.00
29	Proctor, Diane	Proctor, Kelly	1/31/2023	6/9/2023	129	37300.00
30	Darien P.S.	Hagander, Ashley	1/20/2023	5/12/2023	112	11350.00
31	Stamford P.S.	Academic Support for ESS/BGC	1/23/2023	3/17/2023	53	26735.00
32	Lamendola, Kristin	Fallon, Kyle	1/30/2023	4/28/2023	88	17525.00
33	Norwalk P.S.	Sullivan, Jennifer	1/23/2023	3/17/2023	53	5900.00
34	Merrill, John	Merrill, Poppy	1/23/2023	5/12/2023	109	14980.00
35	Stamford P.S.	Vita, Sophia	2/3/2023	4/14/2023	70	2025.00
36	Kliatchko, Vladimir	Kilatchko, Robin	1/27/2023	6/9/2023	133	11525.00
37	Private	Lovett, Chloe	2/6/2023	5/5/2023	88	28375.00
38	Bradley, Ashley	Bradley, Oliver	2/13/2023	3/31/2023	46	12300.00
39	Blanchard, Robert	Blanchard, Henry	1/30/2023	3/4/2023	33	6720.00
40	Nemec, Suzanne	Nemec Phillip	2/22/2023	3/15/2023	21	2450.00
41	Kornstein, Andrew	Kornstein, Lleyton	3/6/2023	5/12/2023	67	19200.00
42	Greenwich P.S.	Casey, Thalia	2/27/2023	6/16/2023	109	29500.00
43	Town of Darien	Vasquez, Enrique	3/2/2023	5/15/2023	74	36775.00
44	Nudelman, Nikki	Nudelman, Sammy	3/2/2023	5/12/2023	71	15860.00
45	Norwalk P.S.	Botens Daniel	3/13/2023	6/16/2023	95	11350.00
46	Norwalk P.S.	Sullivan, Jenniver	3/20/2023	5/3/2023	44	5900.00
47	Private	Sciglimpaglia, Eden	3/13/2023	6/16/2023	95	15000.00
48	Sherman, Scott	Sherman, Matt	3/6/2023	7/14/2023	130	11525.00
49	Town of Darien	Tucker, Thier	3/20/2023	6/9/2023	81	11850.00
50	Stamford P.S.	Academic Support for ESS/BGC	3/20/2023	5/5/2023	46	26735.00
51	Private	Nusseibeh, Anisa	3/27/2023	5/19/2023	53	15360.00
52	Lamendola, Kristin	Fallon, Kyle	3/27/2023	6/9/2023	74	5675.00
53	Stamford P.S.	Condlin, Emma	3/29/2023	6/16/2023	79	11850.00
54	Mottola, Thomas	Mottola, Sakae	3/27/2023	5/12/2023	46	14750.00
55	Greenwich P.S.	Ginste, Elsa	4/3/2023	6/16/2023	74	14300.00
56	Stamford P.S.	Sikiotis, Tristen	4/11/2023	6/23/2023	73	23200.00
57	Private	Howe, Alexandar	4/5/2023	5/12/2023	37	15250.00
58	Private	Nusseibeh, Sarimir	3/30/2023	5/19/2023	50	15360.00
59	Darien P.S.	Gracia, Jeraldine	4/17/2023	6/30/2023	74	29100.00
60	Goodwin, Seth	Goodwin, Sage	4/19/2023	6/9/2023	51	3840.00
61	Stamford P.S.	Talbot, Jason	5/15/2023	6/30/2023	46	9350.00
62	Josh, Gershon	Gershon, Josh	4/27/2023	6/9/2023	43	2950.00
63	Darien P.S.	Piersol, Gavin	5/4/2023	6/30/2023	57	20870.00
64	Darien P.S.	Hagen, Duke	4/26/2023	6/30/2023	65	23425.00
65	Stamford P.S.	Academic Support for ESS/BGC	5/8/2023	6/15/2023	38	26735.00
66	Greenwich P.S.	Blackwell, Ru	5/9/2023	6/16/2023	38	15250.00
67	Stamford P.S.	Franco, Zaire	5/15/2023	6/23/2023	39	15750.00
68	Darien P.S.	Johnson, William	4/27/2023	5/10/2023	13	2460.00
69	Northfield Mount Herman	Thomas, Gabby	5/9/2023	6/23/2023	45	5900.00
Sheet1

Cell Formulas
Range	Formula
E6:E69	E6	=DAYS(D6,C6)

 

[JamesCanale]

MrExcelPlayground17.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								2022								2023
2	District/Parent	Student	Duration			Amount		May 2022	Jun 2022	Jul 2022	Aug 2022	Sep 2022	Oct 2022	Nov 2022	Dec 2022	Jan 2023	Feb 2023	Mar 2023	Apr 2023	May 2023	Jun 2023	Jul 2023	Aug 2023	Sep 2023	Oct 2023
3							Expected	932.43	1070.57	552.55
4
5	Murray, Lisa	Murray, Jake	Start	End		187.5
6	Stamford	Charly, Peter	7/5/2022	9/17/2022	74	2555.55				$920.00	$1,056.29	$579.26
7	Darien P.S.	Johns, Judah	6/29/2022	9/23/2022	86	10591.27			$243.48	$3,773.90	$3,773.90	$2,799.99
8	Norwalk P.S.	Botens Daniel	12/1/2022	3/10/2023	99	22700									$7,037.00	$7,037.00	$6,356.00	$2,270.00
9	Leonard Santorelli	Bates, Sienna	11/21/2022	1/13/2023	53	14750								$2,731.48	$8,467.59	$3,550.93
10	Darien P.S.	Herne, Anabel "Tobi"	12/5/2022	1/20/2023	46	15250									$8,760.64	$6,489.36
11	Merrill, John	Merrill, Poppy	12/5/2022	1/6/2023	32	8000									$6,545.45	$1,454.55
12	Stamford P.S.	Academic Support for ESS/BGC	12/5/2022	1/20/2023	46	26735									$15,358.40	$11,376.60
13	Norwalk P.S.	Sullivan Jennifer	12/5/2022	1/20/2023	46	5900									$3,389.36	$2,510.64
14	Darien P.S.	Steinkraus Griffin	1/3/2023	4/7/2023	94	28375										$8,661.84	$8,363.16	$9,259.21	$2,090.79
15	Stamford P.S.	Reicin, Tina	12/16/2022	12/22/2023	371	1260									$54.19	$105.00	$94.84	$105.00	$101.61	$105.00	$101.61	$105.00	$105.00	$101.61	$105.00
16	Greenwich P.S.	Ginste, Elsa	1/3/2023	3/31/2023	87	22700										$7,480.68	$7,222.73	$7,996.59
17	VanWyk, Mark	VanWyk, Beckett	1/3/2023	4/7/2023	94	28375										$8,661.84	$8,363.16	$9,259.21	$2,090.79
18	Lamendola, Kristin	Fallon, Kyle	12/27/2022	12/30/2022	3	910									$910.00
19	Kornstein, Andrew	Kornstein, Lleyton	1/1/2023	3/4/2023	62	14750										$7,257.94	$6,555.56	$936.51
20	Blanchard, Robert	Blanchard, Henry	1/9/2023	1/24/2023	15	2800										$2,800.00
21	Greenwich P.S.	Casey, Thalia	1/9/2023	2/24/2023	46	11800										$5,774.47	$6,025.53
22	Edwards, John	Edwards, Hayley	1/6/2023	2/24/2023	49	11800										$6,136.00	$5,664.00
23	Yahong, Chen	Li, Leon	2/1/2023	4/21/2023	79	23050											$8,067.50	$8,931.88	$6,050.63
24	Prescott, Finnian	Prescott, Claire	1/23/2023	4/21/2023	88	5675										$573.88	$1,785.39	$1,976.69	$1,339.04
25	Sherman, Scott	Sherman, Matt	1/23/2023	4/28/2023	95	28875										$2,707.03	$8,421.88	$9,324.22	$8,421.88
26	Brockman, Rhonda	Brockman, Jack	1/23/2023	5/5/2023	102	23200										$2,027.18	$6,306.80	$6,982.52	$6,757.28	$1,126.21
Sheet9

Cell Formulas
Range	Formula
I2:Y2	I2	=EDATE(H2,1)
H6:Y26	H6	=LET(d,SEQUENCE($D6-$C6+1,1,$C6),r,ROWS(d),a,$F6,p,a/r,m,SEQUENCE(r,1,p,0),f,FILTER(m,EOMONTH(d,-1)+1=H$2),IFERROR(SUM(f),""))
E6:E26	E6	=DAYS(D6,C6)

 

[Sufiyan97]

Thank you very much James.
This is perfect.

Do you have any tip for me to practice on a formula like this?

 

[JamesCanale]

When using a LET formula, the last term is what is going to appear. I'd change the last term to see what each element is doing.

The best way to learn, is to come here and solve peoples problems - but be slow to show your solution. See how other people solve them.