Can I Spreadsheet?
← All functions

WORKDAY

Supported, behaves as documented

Category: Date and time · Last tested 2026-07-04

Support matrix

EngineDocumentedLive-testedVerdict
Excel Yes Not yet n/a
Google Sheets Yes Not yet n/a
LibreOffice Calc Yes Yes (24.2.7.2, 2026-07-04) Supported, behaves as documented

Executed test cases

LibreOffice Calc 24.2.7.2 (tested 2026-07-04)

FormulaDescriptionResultExpectedVerdict
=WORKDAY(DATE(2024,1,1),5) 5 working days after Mon Jan 1, 2024, no holidays supplied 45299 45299
Jan 1, 2024 (Mon) + 5 workdays, skipping the Jan 6-7 weekend, = Jan 8, 2024 = serial 45299		 Matched
=WORKDAY(DATE(2024,1,1),5,DATE(2024,1,3)) Same start/offset as WORKDAY_basic_no_holidays but with Jan 3 excluded as a holiday, pushing the result one calendar day later 45300 45300
With Jan 3 excluded, the 5th workday becomes Jan 9, 2024 = serial 45300		 Matched
=WORKDAY(DATE(2024,1,1),5,A2:A3) holidays argument as a multi-cell range (Jan 3 and Jan 4 both excluded) 45301 45301
With both Jan 3 and Jan 4 excluded, the 5th workday becomes Jan 10, 2024 = serial 45301		 Matched
=WORKDAY(DATE(2024,1,10),-5) Negative days argument counts backward from start_date instead of forward. Verified via https://support.microsoft.com/en-us/office/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33 ("A positive value for days yields a future date; a negative value yields a past date") 45294 45294
Jan 10, 2024 (Wed) - 5 workdays, skipping the Jan 6-7 weekend, = Jan 3, 2024 = serial 45294		 Matched

Docs & syntax