# 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).