Can I Spreadsheet?
← All functions

DAYS360

Supported, behaves as documented

Category: Date and time · Last tested 2026-08-06

Real, executed compatibility results for the DAYS360 function across Microsoft Excel, Google Sheets, and LibreOffice Calc — verified by actually running it. Syntax and links to each vendor’s official documentation are below.

Support matrix

EngineDocumentedLive-testedVerdict
Excel Yes Not yet n/a
Google Sheets Yes Not yet n/a
LibreOffice Calc Yes Yes (25.8.7.3, 2026-08-06) Supported, behaves as documented

LibreOffice version history

We executed the same test cases under each LibreOffice release to show exactly when DAYS360’s support changed — not documentation claims, real results.

LibreOffice versionVerdictTested
24.2.0.3 Supported, behaves as documented 2026-07-19
24.8.7.2 Supported, behaves as documented 2026-07-19
25.2.0.3 Supported, behaves as documented 2026-07-24
25.8.7.3 Supported, behaves as documented 2026-08-06

Executed test cases

LibreOffice Calc 25.8.7.3 (tested 2026-08-06)

FormulaDescriptionResultExpectedVerdict
=DAYS360(DATE(2011,1,30),DATE(2011,2,1)) Microsoft's own documented example, default (US/NASD) method. Verified via https://support.microsoft.com/en-us/office/days360-function-b9a509fd-49ef-407e-94df-0cbda5718c2a 1 1 Matched
=DAYS360(DATE(2011,1,1),DATE(2011,12,31)) A second literal example from the same documentation page, showing the 30-day-month/360-day-year convention 360 360 Matched
=DAYS360(DATE(2024,1,1),DATE(2024,1,31)) US (NASD) method month-end rule: end_date is the last day of its month (Jan 31) and start_date (Jan 1) is before the 30th, so end_date shifts to the 1st of the NEXT month (Feb 1) before the 30/360 day count. Verified via the DAYS360 documentation's description of the US method's end-of-month handling 30 30
Effective dates become Jan 1 -> Feb 1 -> (2-1)*30 + (1-1) = 30		 Matched
=DAYS360(DATE(2024,1,1),DATE(2024,1,31),TRUE) Same date pair as DAYS360_us_method_month_end_shift but method=TRUE (European method): the European rule simply clamps day-31 dates to day 30, with none of the US method's 'shift end_date to next month' logic, giving a genuinely DIFFERENT result (29, not 30) for the identical inputs -- the documented US-vs-European divergence 29 29
Effective dates become Jan 1 -> Jan 30 (31 clamped to 30, no next-month shift) -> (1-1)*30 + (30-1) = 29		 Matched

Docs & syntax