The WORKDAY function takes three arguments: a start date, days, and an optional range for "holidays." To skip weekends, I just need to give WORKDAY the start date from column B, and the day value from column C.
With the value of one day, the result is December 25th, a Monday. WORKDAY skips the weekend.
If I change days to "2" we get December 26th.
Now, December 25th is Christmas, so it wouldn't normally be treated as a workday.
To take holidays into account, we need to provide a range of dates that represent non-working days.
When I add that range as the 3rd argument, you can see that WORKDAY excludes those dates from the calculation.
Finally, what if you need to treat a weekend day, like Saturday, as a workday?
The Excel WORKDAY function takes a date and returns the nearest working day in the future or past, based on an offset value you provide. You can use the WORKDAY function to calculate things like ship dates, delivery dates, and completion dates...
The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates. NETWORKDAYS.INTL excludes Saturday and Sunday by default, but provides a way to specify which days of the week are considered weekends. The function can...