Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

Calculate Weekdays In Excel

Admin
Duration: 11:31
Submitted: 2 months ago
Views: 69

Comments (0)

Link to this video:

Description: In this video, we will calculate and analyze weekdays in excel using various examples. It's inhumane to calculate weekdays or the number of weeks on your fingertips and that's where excel comes in and solves all your problems. In this video, we will learn 3 main functions with examples i.e. WORKDAY function, WEEKDAY function, NETWORK DAY function. You can also browse the timeline below in order to find the correct timeline or skip the parts you already learned.

Table Of Content:
00:00 Introduction
00:55 WEEKDAY Function as name suggests is a form of date function that converts a serial number to a day of the week.
07:02 NETWORK DAY Function is form of date function that returns the number of whole workdays between two dates.
09:21 WORKDAY Function is also form of date function that returns the serial number of the date before or after a specified number of workdays.
11:00 Conclusion