=DAYSINMONTH(date)

Zoho’s DAYSINMONTH help article lists one argument and uses =DAY(EOMONTH(...;0)) as an alternative. This is important for portability: the dedicated Zoho function avoids an extra nested expression, but an EOMONTH-based calculation is familiar in Excel.

A leap year is usually divisible by 4, except a century year is a leap year only if divisible by 400. Thus 2000 is leap and 1900 is not. This is a Gregorian calendar property, not evidence that every historical date serial works in every spreadsheet application. The worked examples below use modern valid dates.

Import the accompanying calendar-boundaries-practice.csv into a sheet named CalendarChecks and convert date strings in columns B:D to true dates. For this page, the relevant columns are B = Report date, E = Monthly fee, and F = Days used. The other columns support companion WEEKS tutorials. Avoid assuming that a CSV’s 2024-02-29 string was automatically recognized as a date; inspect the imported cell format.

Step-by-step: determine the month length

1. In H1, enter Days in month.
2. In H2 enter =DAYSINMONTH(B2) and format H2 as a whole Number, not a Date.
3. Fill H2 down through H9. Check against the following independently computed predictions:

4. To test a 30-day month not present in the CSV, place an actual April 15, 2026 date in another cell or construct it without ambiguous text: =DAYSINMONTH(DATE(2026;4;15)) should produce 30 according to independent Gregorian calendar arithmetic.
5. Compare your native outputs before relying on the examples operationally; no Zoho workbook was executed in this research pass.

Why February differs: The formula uses the year from the input date as well as the month. A hard-coded list saying February always has 28 days fails in leap years. The leap-day row demonstrates the function’s most valuable edge case.

Suppose reporting entries are stored in B2:B9 and a final review is required only if an entry is on the last day of its month. Combine DAY and DAYSINMONTH:

=IF(DAY(B7)=DAYSINMONTH(B7);"Month end";"Earlier in month")

For B7 = February 29, 2024, the independent result is Month end. For B4 = October 11, 2026, it is Earlier in month. Because DAY returns the day number and DAYSINMONTH returns the month’s maximum day number, equality identifies the final calendar day. This is useful for cutoff checks and monthly close dashboards, but it does not determine a business-day cutoff or bank holiday rules.

You can also construct the last-day date rather than a flag:

=DATE(YEAR(B7);MONTH(B7);DAYSINMONTH(B7))

Independent result: February 29, 2024 (display depends on date formatting). This formula deliberately uses a date constructor with an explicit year, month and day rather than an ambiguous typed string. Zoho also documents the shorter equivalent concept =EOMONTH(B7;0); equivalence for an unusual malformed date must be tested in the actual application.

If the monthly fee is in E and the number of billable calendar days in F, an illustrative calendar-day proration is:

=ROUND(E7/DAYSINMONTH(B7)*F7;2)

For B7 = February 29, 2024, E7 = 290 and F7 = 1, independently calculate 290 ÷ 29 × 1 = 10.00. For B8 = February 28, 2025, E8 = 280 and F8 = 20, the independent result is 280 ÷ 28 × 20 = 200.00. These are arithmetic scenarios—not accounting policy recommendations. Contracts may prorate using working days, 30/360, fixed billing periods, inclusive start/end rules, or taxes instead.

To avoid negative or impossible billed days, set a validation requirement such as 0 <= F7 <= DAYSINMONTH(B7). A record with 31 billed days in February should be reviewed instead of automatically paid. When any cell contains an error or a blank, add business-specific guards rather than quietly calculating a zero charge.

• 28, 29, 30 or 31: A normal Gregorian month is exactly one of those lengths; the year matters only for February. Do not assume arbitrary strings containing 2024-02 are valid date values.
• #VALUE!: Zoho’s generic function help lists invalid argument types. Check that B7 contains a genuine date and not text copied from an export. The exact behavior for malformed text is untested here.
• #NAME!: Check spelling DAYSINMONTH, parentheses, and formula separator. Do not substitute DAY, which is another function.
• #REF!: A referenced date cell may have been deleted or moved.
• Formatting confusion: A return value of 29 shown as an unexpected date can be fixed by displaying the result as Number; the function returns a count.
• Dynamic example: Zoho’s reference prints a result next to DAYSINMONTH(TODAY()). That outcome depends on the day when TODAY is evaluated; a static help-page screenshot is not a prediction about the user’s current month.
• Financial schedules: Calendar days are not the same as workdays. Use the separately documented NETWORKDAYS function if weekends and holidays matter, after verification of those rules.
• Timezone/version uncertainty: The official web article does not specify a minimum first-supported version or guarantee the same parsing in every offline/desktop/mobile client.

Microsoft Excel documents EOMONTH, which returns the date at the end of the month. Combining it with DAY yields the number of days: =DAY(EOMONTH(B7,0)) in a typical English Excel formula. The Zoho reference uses semicolons, e.g. =DAY(EOMONTH(B7;0)). There is no basis in these references to claim that Excel supports a dedicated DAYSINMONTH function under that name; use the documented alternative when migrating. The same EOMONTH-and-DAY technique can be researched for Google Sheets, but no Google Sheets formula was executed or used as evidence about Zoho behavior here.

Zoho’s desktop beta announcement refers broadly to 400+ supported built-in functions. It does not establish native DAYSINMONTH parity across platform, account, or old release. Do not invent a minimum release or attribute the date-count test to a native client.

• Zoho Sheet — function documentation
• desktop beta announcement
• Zoho EOMONTH
• Zoho DAY

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.