ExcelFlux

WORKDAY.INTL function

Calculate a delivery date in working days.

Date and time

Where can you use it?

Planning and operations teams. Use this group to work with dates and times in calendars, delivery schedules, shifts and period reporting.

Scenario in the workbook

Move deadlines using an explicit weekend code. Negative offsets move backward.

A worked example from the workbook

RowAB
6InputComparison
7460231
8460232
946023-1
Record 1
=WORKDAY.INTL(A7,B7,1)

Expected result46024

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=WORKDAY.INTL(DATE(2026,11,27),2,1)
Turkish Excel · tr-TR
=İŞGÜNÜ.ULUSL(TARİH(2026;11;27);2;1)

Example and expected result

The next two business days after Friday, November 27, are Monday and Tuesday. Weekend code 1 excludes Saturday and Sunday.

Expected result December 1, 2026.

Worked examples

Move deadlines using an explicit weekend code. Negative offsets move backward.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Input Comparison
7 46023 1
8 46023 2
9 46023 -1
Case Formula Expected result
Record 1 =WORKDAY.INTL(A7,B7,1) 46024
Record 2 =WORKDAY.INTL(A8,B8,1) 46027
Record 3 =WORKDAY.INTL(A9,B9,1) 46022
Microsoft Excel reference