WORKDAY.INTL

Formulas / WORKDAY.INTL
Calculate the nearest working day in the future or past using an offset value.
==WORKDAY.INTL(start_date,days,[weekend],[holidays])
  • start_date - [REQUIRED] a valid Sourcetable date
  • days - the number of days in the future or past to move from the start_date
  • weekend - [OPTIONAL] specifies which days of the week should be considered weekends
  • holidays - [OPTIONAL] a list of dates that should be considered non-work days

Examples

  • =WORKDAY.INTL(A1,1)

    The WORKDAY.INTL function can be used to find the number of days between two dates, and it will take into account any holidays or days off that are specified. The default parameters are to exclude Saturday and Sunday.

  • =WORKDAY.INTL(A1,1,11)

    The WORKDAY.INTL function can also be used to exclude a single day of the week. For example, if you wanted to exclude Sundays only, you could use the syntax above. The 11 indicates that Sunday is the day to be excluded.

  • =WORKDAY.INTL(A1,1,11,C1:C3)

    You can also use the WORKDAY.INTL function to exclude specific dates in addition to a day of the week. For example, if you wanted to exclude a Monday, Wednesday and Friday, you could use the syntax above. The C1:C3 indicates the range of dates to be excluded, in addition to Sundays.


Summary

The WORKDAY.INTL function is used to calculate a date that is a certain number of workdays before or after a given date, with custom parameters for what days are considered weekends.

  • The WORKDAY.INTL function calculates the nearest working day in the future or past and takes four arguments: start_date (required), days (number of days in the future or past from the start_date), weekend (optional, number of days of the week should be considered weekends), and holidays (optional).

Frequently Asked Questions

What is the WORKDAY.INTL function?
The WORKDAY.INTL function is a Sourcetable function that returns the serial number of a date before or after a number of workdays. It is useful for calculating future or past dates, taking into account weekends and holidays.
What arguments does the WORKDAY.INTL function require?
The WORKDAY.INTL function requires two arguments: start_date and days. The start_date argument is the date from which the WORKDAY.INTL function will calculate the future or past date. The days argument is the number of days before or after the start_date.
Are there any optional arguments for the WORKDAY.INTL function?
Yes, there are two optional arguments: weekend and holidays. The weekend argument indicates which days of the week are weekend days. The holidays argument is a list of dates to exclude from the calculation.
How can the WORKDAY.INTL function be used?
The WORKDAY.INTL function can be used to calculate future or past dates, taking into account weekends and holidays. It is useful for scheduling tasks, calculating due dates, or managing deadlines.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV