Calculate due dates with the WORKDAY function

Tip: Calculate due dates with the WORKDAY function

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:

Duration 
3:40
Author 

Related shortcuts

CtrlShift~

~

Leave a Reply

Your email address will not be published. Required fields are marked *