WORKDAY.INTL function - Zoho Sheet - Help Guide

WORKDAY.INTL

Returns the end date away from a given number of working days. It allows customized weekend days for the calculation.
 
Syntax

WORKDAY.INTL(start_date; days; [weekend]; [hol_range])
start_date: The starting date for the calculation. E.g. "1/17/20"
days: The number of working days to count from the start_date. Counts backwards if negative. E.g. 12
weekend: Number indicating the weekend days. Defaults to 1 if omitted.
hol_range: A list or range containing the dates that represent the non-working days (holidays). E.g. D2:D5
 
Weekend
Days
1
Saturday, Sunday
2
Sunday, Monday
3
Monday, Tuesday
4
Tuesday, Wednesday
5
Wednesday, Thursday
6
Thursday, Friday
7
Friday, Saturday
11
Sunday Only
12
Monday Only
13
Tuesday Only
14
Wednesday Only
15
Thursday Only
16
Friday Only
17
Saturday Only
 
Examples
 
Formula
Result
=WORKDAY.INTL("1/1/2020";12;2;D2:D5)
1/17/20
=WORKDAY.INTL("1/1/2020";180;5)
9/8/20
=WORKDAY.INTL("3/2/2020";-5;15)
2/25/20
 
Get a hands-on experience of the function in the embedded range below.



Possible Errors
 
Errors
Meaning
#N/A!
  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.
#NAME!
  • The function name is incorrect or invalid.
  • The given defined name (if any) is invalid.
  • There is a typo in the defined name used in the function.
  • Double quotes are missing for text values in the function.
  • Colon missing in a cell range reference.
#VALUE!
  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.
#REF!
  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.
 
Similar Functions
  • NETWORKDAYS
  • NETWORKDAYS.INTL
  • WEEKS
  • WORKDAY