DAYS in Zoho Sheet: Syntax, Real Examples and Troubleshooting

=DAYS(end_date; start_date)

Return: A signed numeric day difference. Zoho states explicitly that it subtracts the start date from the end date. It does not describe DAYS as counting business days, excluding holidays or counting both endpoints. Zoho’s official help gives examples with quoted text dates, but these can be locale dependent; entering actual date cells or using DATE(year;month;day) is safer.

Make a new sheet called BillingDates and enter the following values. Column B must contain actual date cells, not ISO strings imported as text; select the column and apply a date format. Enter the dates manually or construct them with DATE(year;month;day) if CSV import treats YYYY-MM-DD as text. Column C must be a signed integer; D is also a date. The accompanying CSV supplies source text only and cannot itself certify inferred spreadsheet data types.

Use the semicolon function separator used in Zoho’s official web documentation. Cell formats may show dates differently; the expected outputs below are in ISO YYYY-MM-DD only to remove locale ambiguity. Dates and output values were calculated independently, not obtained by running formulas in Zoho.

1. In E1, write Elapsed days. In E2, enter =DAYS(D2;B2).
2. In the first example, D2 = 2024-03-10, B2 = 2024-01-31, so the difference is 39 days. The leap day 2024-02-29 is part of that interval.
3. Drag/fill E2 down to E9. The independent reference answers are:

4. Reverse the dates: =DAYS(DATE(2024;1;31);DATE(2024;3;10)) → -39, not +39. You can wrap ABS(...) around a formula only if you genuinely need absolute elapsed distance.
5. Same date: =DAYS(DATE(2026;10;11);DATE(2026;10;11)) → 0, rather than 1. If a separate policy counts both start and end calendar dates, consider =DAYS(end;start)+1 only when end ≥ start and the policy explicitly requires an inclusive count.
6. Leap-year boundary: =DAYS(DATE(2025;1;1);DATE(2024;1;1)) → 366. For 2024-02-28 to 2024-03-01, the result is 2.

All values above were calculated with Python’s calendar/date arithmetic. They are expected outputs to test in Zoho Sheet, not native spreadsheet results.

Suppose column B is the date you received an order and column D is its contractual deadline. For a 30-calendar-day service-level warning put in F2:

=IF(DAYS(D2;B2)>30;"Over 30 days";"Within 30 days")

For row 2 the expected label is Over 30 days (39 > 30); for row 4 the expected label is Within 30 days (17 ≤ 30). Fill down to categorize other cases. If the rule counts the start day as day 1, change the business logic consciously; don’t redefine DAYS itself.

For an overdue amount as of the current date you might use =IF(TODAY()>D2;DAYS(TODAY();D2);0). Its output is time dependent and must be verified with the spreadsheet time zone and recalculation behavior. If the end date might be empty, decide whether blank means not due, unknown or invalid before applying the formula; coercion of empty cells was not independently tested inside Zoho.

For business days excluding weekends, see the separate Zoho official NETWORKDAYS reference. DAYS does not implement weekend exclusions.

Microsoft’s Excel DAYS function uses DAYS(end_date, start_date) with a comma in its US-language examples and explicitly explains how it handles text dates and out-of-range dates. Zoho’s help uses semicolons and does not document all those precise Excel edge conditions. A like-named function is not proof of identical date parsing, error messages or behavior across different software versions.

=end_date-start_date can also calculate a numeric interval when both spreadsheet date cells are valid, but cell number formatting may display that difference as a date. DAYS makes intended units clearer. Avoid DATEDIF(...;"D") or DAYS360(...) unless their special behavior matches your requirement; a 360-day financial convention is not an ordinary calendar-day count.

Zoho’s current public help lists this function, but does not provide its original release date or a comprehensive feature matrix for web, mobile, and older clients. As of 2026-10-11, the Zoho September 2026 update says the Windows/macOS beta desktop apps use Excel-native formula syntax by default for offline files. Consequently, check the editor’s suggestions for argument separator and import interpretation before copying formulas verbatim. A comma is commonly used in Microsoft Excel examples; this page uses Zoho help’s semicolons. Formula names matching other apps do not establish feature-identical versions.

For date display and parsing, see Zoho Spreadsheet locale and calculation settings: File → Spreadsheet Settings → Locale offers date format, time zone and separators. Use DATE(2024;1;31) rather than ambiguous text such as "1/31/24" in portable examples. Some serial-number displays or historical-date conventions may differ between applications; this is not a verified cross-application cell-level comparison.

• Zoho Sheet — function documentation
• NETWORKDAYS reference
• 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.