From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions

Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Workday tabulations with NETWORKDAYS, WORKDAY, and SEQUENCE functions

“

- [Instructor] When you're working with dates and trying to tabulate working day type information, the functions you'll be relying on are likely to be workday and net workdays. And notice in the gray panel to the right, each of them has what's called an international companion, functions that allow us to tabulate information based on different kinds of weekends in different cultures. Let's first start with a simple example here of how we might use the workday function. We've got a project that begins on January 8th of 2024. It's a 65 day project. We simply want to know when it ends. I've got the date in cell B2. So in cell C2, I'll write a simple formula, at least initially that we in the long run would not use, but just to show the 65 day project, if we didn't have any weekend concerns. Maybe it is seven days a week. A simple formula here that takes a starting date plus 65 gives us an answer, but it is counting Saturdays…

Contents