DAY in Zoho Sheet: Extract Day of Month and Detect Month End

The syntax here follows Zoho Sheet’s currently published English function help, checked October 11, 2026. Those articles do not publish a per-function introduction version, desktop/mobile support matrix, or guarantee of identical historical behavior. Zoho’s September 2026 What’s New says the Windows and macOS beta desktop apps support Excel’s native formula syntax by default for offline files. As a result, separator punctuation and behavior must be checked in the actual web or desktop editor: this tutorial shows semicolons exactly as in the official Zoho function article, and does not silently equate them with comma-delimited Excel formulas.

Zoho’s spreadsheet locale settings control date display, date interpretation, and time zone, among other items. The intended results below are calendar dates or integers; a date that displays differently after import is not necessarily a different calculated date.

Create a new sheet with these headers: A1 Event, B1 Year, C1 Month, D1 Day, E1 Event date. Enter the six data rows below. The dates shown in column E are expected date displays, not date-text strings you should paste.

In E2, enter =DATE(B2;C2;D2) using the vendor-reference punctuation and fill the formula down through E7. Then format E2:E7 as dates (for example, ISO-style YYYY-MM-DD). Depending on locale, the visible representation may differ without changing the underlying date. If CSV is easier, use the attached date-components-practice.csv for columns A:D, and build E2:E7 with DATE after import. This is important because imported ISO-looking strings are not guaranteed to be parsed as true dates.

Use the E-column date values, rather than manually typing ambiguous strings like 03/04/2024, in the formulas that follow. For a quick single-cell check independent of a dataset, nest DATE(2024;2;29) inside the function.

In F2 enter =DAY(E2) and fill down to F7. From the six prepared event dates, the expected F2:F7 values are 29, 15, 11, 31, 1, 3.

The DAY output is an integer and can be used in conditions. If the date input is formatted as a number, that does not change the requested day component as long as the underlying value is a valid date.

Mark records that occur on the last calendar day of their month:

=IF(DAY(E2)=DAY(DATE(YEAR(E2);MONTH(E2)+1;0));"Month end";"Other day")

Explanation: MONTH(E2)+1 means the next month; the nested DATE with day zero gives the prior month’s last day; DAY compares that last day to the event day. For E2=2024-02-29 the result is Month end; for E3=2025-01-15 the result is Other day. For E5=2023-12-31 the result is Month end. This is appropriate for calendar-month billing. It does not shift a weekend deadline to the last working day.

• Not a weekday: DAY=1 means first of the month, not Monday. Use WEEKDAY for weekly schedules.
• Leap years: February ends on the 29th in 2024 but on the 28th in 2025. Avoid hard-coded month-end day tables.
• Not unique on its own: 15 occurs every month; include YEAR and MONTH when grouping events by full calendar date.
• Date parsing: If a text value produces #VALUE! or a strange answer, reconstruct with DATE rather than relying on locale-dependent quoted dates.
• Cell errors: #NAME! may indicate a misspelled function name and #REF! may indicate a deleted reference, as Zoho’s generic troubleshooting table indicates.
• Malformed components: Using DATE to normalize month/day overflow is different from validating that a user entered a valid date; add validation when needed.

The DAY(date) idea also exists in Excel, LibreOffice Calc and Google Sheets for normal date values, but identical text parsing is not guaranteed. Prefer constructing DATE from numeric parts after import, and verify argument separators for nested formulas. Zoho’s September 2026 Windows/macOS beta change to Excel’s native offline formula syntax does not prove that every historical or mobile client accepts the same punctuation.

• DATE in Zoho Sheet
• YEAR in Zoho Sheet
• MONTH in Zoho Sheet
• DAY in Zoho Sheet
• WEEKDAY in Zoho Sheet
• IF in Zoho Sheet

• Zoho Sheet — function documentation
• spreadsheet locale and calculation settings

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.