List all days in a month with 1 Click #googlesheets

Don't type out the day of the month for each row.

Don't even drag down from 1 to 31 (or however many days there are in the month).

Here's how to do it:
Create a sheet for each month of the year
In each sheet, in cell A1, enter Month and Year (e.g. Jan 2024)
Cell A2 contains this formula:
=SEQUENCE(DAY(EOMONTH(A1,0)

This works even for February in leap years, like 2024.

EOMONTH calculates the end of the month (the date last day of the month)
DAY turns that last date into a day number for that month.
SEQUENCE makes the number of rows for that number.

[laughingkuma]

Thanks for this - wondering how would you make the numbers for the days go across a row, rather than down a column?

[reytorres]

this is exactly what I want but is say “ERROR” you know why?