This video show how to calculate due dates with the WORKDAY and WORKDAY.INTL functions. You can use WORKDAY to calculate intelligent ship dates, delivery dates, and completion dates that take into account non-working days.
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.
If you need to add or subtract business days (workdays) to a date so that you can calculate a date in the future or past that skips weekends (and holidays), you can use the WORKDAY function. Holidays are optional. In the example, the formula in D6...
To get a date 6 months in the future, on the next work day, you can use a formula based on the WORKDAY function, with help from EDATE. In the example shown, the formula in C6 is = WORKDAY ( EDATE ( B6 , 6 ) - 1 , 1 , B9:B11 ) How this formula works...
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 function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as 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...
I LOVE your site. It helps me frequently as I have no formal training but I'm very logic oriented and this site is put together so very well and has assisted me so very much! You've improved the quality of my life. -Mike