Excel Functions

Excel WORKDAY.INTL Function

Pinterest LinkedIn Tumblr

The WORKDAY.INTL function takes a date and returns the nearest working in the future or past, based on an offset value you provide. Unlike the WORKDAY function, WORKDAY.INTL allows you to customize which days are considered weekends (non-working days).

Purpose of Excel WORKDAY.INTL Function

Excel WORKDAY.INTL function can be used when you want to get the date after a given number of working days.This function is best used when you want to calculate the invoice due date, project due date, delivery date, etc.

Return value

It returns the serial number of the date that is after or before the specified number of working days (from the specified start date).

Syntax

=WORKDAY.INTL (start_date, days, [weekend], [holidays])

Arguments

ArgumentsDescriptionRemarks
start_dateThe start dateMandatory
daysThe end dateMandatory
weekendSetting for which days of the week should be considered weekends Optional
holidaysA list of one or more dates that should be considered non-work days Optional

Usage notes

  • A Date can be entered as:
  • A result from some other function.
  • A date stored as text.
  • A date entered as text (In double quotes).
  • A Weekend could be any two consecutive days or any single day of the week.
  • In case of part-time jobs or non-consecutive non-working days, type the below format in [weekend] section.

Availability

Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment