Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.
Söz dizimi
WORKDAY.INTL(start_date, days, [weekend], [holidays])Bağımsız değişkenler
start_datezorunlu
The date from which the calculation begins.
dayszorunlu
The number of non-weekend and non-holiday days before or after start_date.
weekendisteğe bağlı
A number or string specifying which days are weekends (default is Saturday and Sunday).
holidaysisteğe bağlı
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).