Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.
Sintaxe
WORKDAY.INTL(start_date, days, [weekend], [holidays])Argumentos
start_dateobrigatório
The date from which the calculation begins.
daysobrigatório
The number of non-weekend and non-holiday days before or after start_date.
weekendopcional
A number or string specifying which days are weekends (default is Saturday and Sunday).
holidaysopcional
An optional range of dates to be excluded from the working calendar.
The WORKDAY.INTL function calculates a future or past date by excluding weekends and specified holidays. Unlike the standard WORKDAY function, it allows you to define which days of the week are considered weekends using a string or index number.
=WORKDAY.INTL("2023-01-01", 5, 1)→2023-01-09Calculates the date 5 workdays after Jan 1, 2023, treating Saturday and Sunday as weekends.
Select a cell
Click on the cell where you want to display the resulting date.
Enter the formula
Type =WORKDAY.INTL followed by the start date, the number of days, and your weekend preference.
Format the result
Ensure the cell is formatted as a Date to view the result correctly.
Use the 'weekend' argument with a specific code (e.g., 11 for Sunday only) or a string (e.g., '0000011' for Friday and Saturday).