1
00:00:00,080 --> 00:00:04,368
Four workdays after Tuesday, November twenty-fourth is not the following

2
00:00:04,368 --> 00:00:07,487
Monday when Thursday and Friday are company closures.

3
00:00:07,487 --> 00:00:10,996
Our fictional schedule skips those dates and the weekend.

4
00:00:10,996 --> 00:00:15,285
We will build real Excel dates and verify Wednesday, December second

5
00:00:15,285 --> 00:00:17,234
as the fourth working day.

6
00:00:17,834 --> 00:00:21,539
The two CSV files store year, month, and day as numeric

7
00:00:21,539 --> 00:00:25,582
parts so Excel does not have to guess a text date format.

8
00:00:25,582 --> 00:00:29,287
Use DATE to create the Tuesday start date in F2 and

9
00:00:29,287 --> 00:00:34,003
both closure dates in a two-cell holiday range, then format them as dates.

10
00:00:34,603 --> 00:00:38,287
First calculate =WORKDAY(F2,E2) without any holiday list.

11
00:00:38,287 --> 00:00:42,789
It counts Wednesday, Thursday, Friday, then Monday as the four workdays,

12
00:00:42,789 --> 00:00:45,245
so the result is November thirtieth.

13
00:00:45,245 --> 00:00:50,975
That is a useful baseline but wrong for this company's two-day closure.

14
00:00:51,575 --> 00:00:54,904
Add H2:H3 as WORKDAY's third argument.

15
00:00:54,904 --> 00:00:59,481
Excel excludes those two dates as well as Saturday and Sunday.

16
00:00:59,481 --> 00:01:05,307
The formula should move the deadline from Monday, November thirtieth to Wednesday, December second.

17
00:01:05,307 --> 00:01:09,885
Check that H2:H3 contains date values rather than text labels.

18
00:01:10,485 --> 00:01:12,897
November twenty-fifth is day one.

19
00:01:12,897 --> 00:01:16,917
The next two dates are closed, followed by the weekend.

20
00:01:16,917 --> 00:01:21,339
Monday November thirtieth is day two, Tuesday December first is day

21
00:01:21,339 --> 00:01:24,555
three, and Wednesday December second is day four.

22
00:01:24,555 --> 00:01:26,967
Independent counting confirms the formula result.

23
00:01:27,567 --> 00:01:31,948
This result assumes Saturday and Sunday are nonworking days and that

24
00:01:31,948 --> 00:01:34,735
both fictional closures apply to the team.

25
00:01:34,735 --> 00:01:37,125
Another weekend pattern requires WORKDAY.INTL.

26
00:01:37,125 --> 00:01:41,505
If Excel shows a serial number, format the output as Date;

27
00:01:41,505 --> 00:01:45,487
do not replace the calculated value with manually typed text.