Look Who it Was Random video

Excel - Mastering Pivot Tables and Billable Days in Excel | Excel Tutorial - Episode 1018

839 views · Published 20 May 2009 · 5:34 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Mastering Pivot Tables and Billable Days in Excel.

Welcome back to the MrExcel netcast! In this episode, we will be discussing how to analyze and file up a pivot table with a massive amount of data. We will also be solving a problem presented by one of our viewers, Shawn, and taking a closer look at a formula from the Excel Gurus Gone Wild book.

Have you ever needed to figure out the number of days elapsed between two dates? It may seem simple, but what if you only want to count the number of work days, excluding weekends and holidays? In this video, we will be exploring the =NETWORKDAYS function, which is available in Excel 2007 and can be enabled in Excel 2003 by turning on the Analysis Tool-pack.

But what if you only want to count specific days of the week, such as Mondays, Wednesdays, and Fridays? We will also be diving into the WEEKDAY function and using the MOD function to create a custom function that can easily be customized for any days of the week. This is just a small taste of the power of VBA, which we will be exploring further in our Livelessons Power Excel Macro course.

And finally, in tomorrow's episode, we will be looking at an insane formula that can solve this problem without using any VBA. This clever formula is sure to impress and save you time in your data analysis. So don't forget to tune in for our next netcast from MrExcel!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Figure out the number of billable days between two dates. Episode 1018 looks at ways to count the number of days, number of workdays, or number of Monday-Wednesday-Friday dates between two dates.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Introduction
(00:14) Introduction to the formula
(00:25) Using the NETWORKDAYS function
(01:32) How to enable the Analysis Tool-pack in Excel 2003
(02:00) Counting specific days of the week
(03:30) Creating a custom function in VBA
(04:19) Using the custom function to count specific days
(05:00) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Analysis Tool-pack
Counting specific weekdays
Custom function
Days elapsed between two dates
Insane formula
MOD function
NETWORKDAYS function
Pivot table
Power Excel Macro
VBA code
WEEKDAY function


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152425/

More from this channel