Calc - create a list of the last date of each month

[BlueLagoon]

I would like to create a list of the last date of of each month. In Excel I can use =eomonth(date(2025,sequence(24),1),0) but I can’t get this to work in Calc. Any help appreciated.

[Villeroy]

=DATE(2025;ROW(A2);0)
The DATE function can calculate dates. The zeroth day of a month is the previous month’s last day.

[EarnestAl]

It works in 28.4 and after. Did you Ctrl+Shift+Enter the array formula?
Try deleting a parenthesis and typing it back then press Ctrl+Shift+Enter

[BlueLagoon]

Thanks, but that only gives me the last day of the January. I’m hoping to get a list of the say the next 24 months last day.

[Villeroy]

Drag down the cell as far as needed.
Or select 24 cells and enter the formula with Alt+Enter.
Stop using ChatGPT!

[BlueLagoon]

Thanks EarnestAI, that worked great.

[BlueLagoon]

@Villeroy

=DATE(2025;ROW(A2);0)

That also worked, thanks.
I didn’t know that I was using ChatGPT

[fpy]

@Villeroy

Stop using