In this video, we'll look at how to calculate due dates with the WORKDAY and WORKDAY.INTL functions.
The WORKDAY function returns a date in the future or past that takes into account weekends and optionally holidays.
You can use the WORKDAY function to calculate things like ship dates, delivery dates, and completion dates that need to take into account working and non-working days.
Now, to review, date calculations can be really simple.
To add 1 day to the date in B5, I can put 1 in C5, then just use the formula:
And this gives us December 23, as expected.
If I change C5 to -1, we get December 21.
This works because Excel stores all dates as serial numbers...
But what happens when you need to skip weekends or holidays? Well, that's what the WORKDAY function is for.
Let me first apply a custom number format to the dates so we can easily see the day of week.
Custom date format = mmm dd-mmm-yyy
The WORKDAY function takes 3 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.