Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to find the number of days in a month in Excel and Google Sheets
Excel & Google Sheets
=DAY(EOMONTH(A2,0))Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter a date in column A (e.g., A2 = 2024-02-01). This can be any date within the month you want to measure.
- 2In the result cell, enter =DAY(EOMONTH(A2,0)). EOMONTH(A2,0) returns the last day of the same month as A2, and DAY() extracts its day number.
- 3Press Enter. The result is the total number of days in that month (e.g., 29 for February 2024, a leap year).
Tips
- To get days in the next month, change 0 to 1: =DAY(EOMONTH(A2,1)). Use -1 for the previous month.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Does this formula handle leap years automatically?
Yes. EOMONTH always calculates the true last day of the month, so February returns 29 in leap years and 28 otherwise.
What if my date is stored as text?
Wrap it in DATEVALUE: =DAY(EOMONTH(DATEVALUE(A2),0)) to convert text to a proper date first.