Maximum End of Month Date Array Formula

[ricafonyat]

What array formula (CTRL SHIFT ENTER) should I use to calculate the largest projected date in cell E2 considering the number of months shown in column B and just referencing columns A and B in the formula?

Thanks in advance
Best Regards

 

[Cubist]

Since you have 365, you shouldn't need CTRL SHFT ENTER. Try

=MAX(A2:A4+B2:B4)

 

[Jeffrey Mahoney]

Please try
=EOMONTH(MAX(A2:A4+(B2:B4*30)),0)

 

[Cubist]

I realized I added days instead of months. Not used to the date format. Try

=MAX(EDATE(+A2:A4,+B2:B4))

 

[Jeffrey Mahoney]

=MAX(EDATE(+A2:A4,+B2:B4))

I tried that formula without the + before each range and got an error. I don't even know why adding the plus would work?

 

[ricafonyat]

What array formula (CTRL SHIFT ENTER) should I use to calculate the largest projected date in cell E2 considering the number of months shown in column B and just referencing columns A and B in the formula?

View attachment 113137

Thanks in advance
Best Regards

Sorry Guys, I did a mistake:
I did the wrong question !
In fact, I am looking for a month sequence - with the end of month date - from a base date (Jun-30-2024) until the Max Date Projected.
Could you help me please?

 

[Jeffrey Mahoney]

In fact, I am looking for a month sequence - with the end of month date - from a base date (Jun-30-2024) until the Max Date Projected.

How are you going to use that? As a label? In column headers? In a formula?

 

[ricafonyat]

How are you going to use that? As a label? In column headers? In a formula?

As headers

 

[ricafonyat]

As column headers

 

[Cubist]

Try.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Date	# Months
2	1/15/2024	12		Base Date	6/1/2024
3	12/15/2024	5
4	1/10/2025	6		Sequence	6/30/2024	7/31/2024	8/31/2024	9/30/2024	10/31/2024	11/30/2024	12/31/2024	1/31/2025	2/28/2025	3/31/2025	4/30/2025	5/31/2025	6/30/2025	7/31/2025
5
Sheet3

Cell Formulas
Range	Formula
E4:R4	E4	=EOMONTH(E2,SEQUENCE(1,DATEDIF(E2,MAX(EDATE(+A2:A4,+B2:B4)),"m")+1,0))
Dynamic array formulas.