HDTutorial
EN
How to Calculate Work Days in Excel (Exclude Holidays & Weekends)

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Calculate Work Days in Excel (Exclude Holidays & Weekends)

62,138 views November 10, 2019 9:35

Watch on YouTube
ChannelPresentation Process

Chapters

Description from the creator

How to Calculate Work Days in Excel including WORKDAY, WORKDAY.INTL, NETWORK.DAYS, NETWORKDAYS.INTL
📌Complete Excel Foundation Course: shop.presentation-process.com/p/complete-excel-…
What is covered in this Excel tutorial:
==============
00:00 4 Functions Covered
00:40 Change Date Format
01:20 How to exclude Weekends & Holidays to calculate project end date
02:10 Calculate workdays against a list of holiday dates
03:56 How to change weekends & calculate Work days
06:37 Find No of workdays between 2 days
07:45 Find No of workdays with custom weekends

Download Practice Worksheet:
drive.google.com/file/d/1s6FUr1c27ULCQ5D0uwkvFJ…
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.

About this tutorial

Presentation Process published this 9:35 video tutorial on November 10, 2019. It has been watched 62,138 times on YouTube.

Duration
9:35
Published
November 10, 2019
Views
62,138
Likes
604

Tags

Share

This tutorial in other languages