Dynamic Array For Dates Using SEQUENCE()

[Cubist]

I want to generate the end-of-month array given 2 inputs:
(1) the start date - The start date input can be any day of the month but I want the result array to always be end-of-month.
(2) The length of the array.

I need dynamic array so I don't need to manually copy down the formulas every time.
See the sample below:

Book1
	A	B
1	Start Date	1/25/2022
2	Length	26
3
4	Output	1/31/2022
5		2/1/2022
6		3/1/2022
7		4/1/2022
8		5/1/2022
9		6/1/2022
10		7/1/2022
11		8/1/2022
12		9/1/2022
13		10/1/2022
14		11/1/2022
15		12/1/2022
16		1/1/2023
17		2/1/2023
18		3/1/2023
19		4/1/2023
20		5/1/2023
21		6/1/2023
22		7/1/2023
23		8/1/2023
24		9/1/2023
25		10/1/2023
26		11/1/2023
27		12/1/2023
28		1/1/2024
29		2/1/2024
Sheet1

Cell Formulas
Range	Formula
B4	B4	=EOMONTH(B1,0)
B5:B29	B5	=EOMONTH(B4,0)+1

 

[Cubist]

It should end-of-month.

Book1
	C
4	1/31/2022
5	2/31/2022
6	3/31/2022
7	4/31/2022
8	5/31/2022
9	6/31/2022
10	7/31/2022
11	8/31/2022
12	9/31/2022
13	10/31/2022
14	11/31/2022
15	12/31/2022
16	1/31/2023
17	2/31/2023
18	3/31/2023
19	4/31/2023
20	5/31/2023
21	6/31/2023
22	7/31/2023
23	8/31/2023
24	9/31/2023
25	10/31/2023
26	11/31/2023
27	12/31/2023
28	1/31/2024
29	2/31/2024
Sheet1

 

[Armstrong_N14]

try
on Cell B4: =EOMONTH(B1,0)
on cell B5: =EOMONTH(B4+1,0) then drag til B29

 

[Anonymous1378]

Perhaps try this instead?

Book5
	A	B
1	Start Date	25-Jan-22
2	Length	26
3
4	Output	31-Jan-22
5		28-Feb-22
6		31-Mar-22
7		30-Apr-22
8		31-May-22
9		30-Jun-22
10		31-Jul-22
11		31-Aug-22
12		30-Sep-22
13		31-Oct-22
14		30-Nov-22
15		31-Dec-22
16		31-Jan-23
17		28-Feb-23
18		31-Mar-23
19		30-Apr-23
20		31-May-23
21		30-Jun-23
22		31-Jul-23
23		31-Aug-23
24		30-Sep-23
25		31-Oct-23
26		30-Nov-23
27		31-Dec-23
28		31-Jan-24
29		29-Feb-24
Sheet1

Cell Formulas
Range	Formula
B4:B29	B4	=EOMONTH(B1,SEQUENCE(B2,,0))
Dynamic array formulas.

 

[Cubist]

Perhaps try this instead?

Book5
	A	B
1	Start Date	25-Jan-22
2	Length	26
3
4	Output	31-Jan-22
5		28-Feb-22
6		31-Mar-22
7		30-Apr-22
8		31-May-22
9		30-Jun-22
10		31-Jul-22
11		31-Aug-22
12		30-Sep-22
13		31-Oct-22
14		30-Nov-22
15		31-Dec-22
16		31-Jan-23
17		28-Feb-23
18		31-Mar-23
19		30-Apr-23
20		31-May-23
21		30-Jun-23
22		31-Jul-23
23		31-Aug-23
24		30-Sep-23
25		31-Oct-23
26		30-Nov-23
27		31-Dec-23
28		31-Jan-24
29		29-Feb-24
Sheet1

Cell Formulas
Range	Formula
B4:B29	B4	=EOMONTH(B1,SEQUENCE(B2,,0))
Dynamic array formulas.

Thanks, that works!