Can I Spreadsheet?
← All functions

YEAR

Quirk found

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

Real, executed compatibility results for the YEAR 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) Quirk found

LibreOffice version history

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

LibreOffice versionVerdictTested
24.2.0.3 Quirk found 2026-07-19
24.8.7.2 Quirk found 2026-07-19
25.2.0.3 Quirk found 2026-07-24
25.8.7.3 Quirk found 2026-08-06

Why isn't YEAR working in LibreOffice?

YEAR exists in LibreOffice 25.8.7.3, but it is not a drop-in match for Excel — our executed tests found real behavioral differences (detailed in the test results on this page). If a formula that works in Excel or Google Sheets misbehaves in LibreOffice, compare your usage against the failing cases above before assuming your data is wrong.

Discovered quirks

Executed test cases

LibreOffice Calc 25.8.7.3 (tested 2026-08-06)

FormulaDescriptionResultExpectedVerdict
=YEAR(DATE(2024,3,15)) YEAR applied to a constructed date 2024 2024 Matched
=YEAR(1) YEAR applied directly to the raw serial number 1 (the classic Excel epoch, serial 1 = Jan 1, 1900) 1899 1900
Serial 1 is Jan 1, 1900 in the 1900 date system		 Mismatch
=YEAR(45366.75) A serial with a fractional (time-of-day) component still resolves to the correct calendar year 2024 2024
45366 = 2024-03-15; the .75 fractional day (18:00) is ignored by YEAR		 Matched

Docs & syntax

Related how-to recipes