Skip to main content

fn_workday

Function fn_workday 

Source
pub fn fn_workday(args: &[Expr], ctx: &mut Evaluator<'_>) -> Result<CellValue>
Expand description

WORKDAY(start_date, days, [holidays]) - date after N working days.

Weekdays follow Excel’s serial calendar, where serial 0 is a Saturday and serial 60 (1900-02-29) is a Wednesday. days is truncated toward zero; a negative or post-9999 start or holiday, a non-finite day count, or a result outside the Excel date range returns #NUM!. Holidays are sorted once and walked with a monotone cursor, and the walk is charged as evaluation work before it runs.