TRUECALC
Functions

WORKDAY.INTL

Date N working days from start with custom weekends

Try it

When to use it

When should I use WORKDAY.INTL instead of WORKDAY?

Use WORKDAY.INTL when your working week differs from the standard Monday-Friday schedule, letting you specify custom weekend days via a weekend code or bitmask string.

Used in

operations · hr

Syntax

WORKDAY.INTL(start,days,[weekend],[holidays])

Examples

=WORKDAY.INTL(DATE(1969,7,21),4,1) // => 25409
=WORKDAY.INTL(DATE(1995,8,13),-2,2) // => 34922
=WORKDAY.INTL(DATE(1969,7,21),0) // => 25405

On this page