Expand Month and Days for month based Start Date plus Number of Days

[Sufiyan97]

I have start date and Number of days of stay

I want result as highlighted below

I want a formula for Excel 2013, can someone please help

Book12
	A	B	C	D	E	F
1		Stay			114
2	2/25/2022	114		Expected	Expected
3				2/28/2022	4
4				3/31/2022	31
5				4/30/2022	30
6				5/31/2022	31
7				6/18/2022	18
8
9
Sheet1

Cell Formulas
Range	Formula
E1	E1	=SUM(E3:E7)

 

[Dave Patton]

Date and Time 3.xlsm
	A	B	C	D	E
1		Stay			114
2	25-Feb-22	114		Expected	Expected
3				28-Feb-22	4
4				31-Mar-22	31
5				30-Apr-22	30
6				31-May-22	31
7				19-Jun-22	18
5d

Cell Formulas
Range	Formula
E1	E1	=SUM(E3:E7)
D3:D7	D3	=MIN(EOMONTH($A$2,ROW()-3),$A$2+114)
E3:E7	E3	=MIN(D3-$A$2+1,D3-EOMONTH(D3,-1),114-SUM($E$2:E2))

 

[Sufiyan97]

Thank you very much Dave

Working Perfect.

 

[Dave Patton]

Thanks for the feedback.