WORKDAY.INTL

Get date and working days in future or past

Sponsored Link

WORKDAY.INTL

Purpose 

Get date n working days in future or past

Return value 

Next or previous working date based on inputs

Syntax 

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

Arguments 

  • start_date - The start date.
  • days - The end date.
  • weekend - [optional] Setting for which days of the week should be considered weekends.
  • holidays - [optional] A list of one or more dates that should be considered non-work days.

Usage notes 

WORKDAY.INTL figures out a date that represents the "nearest" working day N days in the past or future. Use a positive number as days for future dates and a negative number for past dates. This function is more robust than the WORKDAY function because it lets you customize which days of the week are considered weekends.

Weekends

By default, WORKDAY.INTL will exclude weekends (Saturday and Sunday) . However, you can control which days are considered weekends, by supplying the codes that appear in the table below for the weekend argument.

Holidays

WORKDAY.INTL can also optionally take into account holidays. For the holidays argument, supply a range that contains holiday dates. These dates are treated as non-working days and will not be included in the result.

Weekend settings

CodeWeekend days
1 (default)Saturday, Sunday
2Sunday, Monday
3Monday, Tuesday
4Tuesday, Wednesday
5Wednesday, Thursday
6Thursday, Friday
7Friday, Saturday
11Sunday only
12Monday only
13Tuesday only
14Wednesday only
15Thursday only
16Friday only
17Saturday only

Notes:

  • If start_date is invalid, WORKDAY.INTL returns the #NUM! error.
  • If start_date + day is invalid, WORKDAY.INTL returns the #NUM! error.
  • If any holiday is invalid, WORKDAY.INTL returns the #NUM! error.
  • If weekend is invalid, WORKDAY.INTL returns the #VALUE! error.

Sponsored Link

0 votes. 0 / 5