Calculate Days Between Dates Excluding Weekends and Holidays

Add to Favorites
Author:

[file link below here or in side column]


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Add Time Together Limiting by Working Hours and Excluding Weekends and Holidays in Excel
Tutorial: Add two times together to get a future date and time that falls within working hours, excl...
Get the Number of Workdays Between Two Dates in Excel
Tutorial: How to calculate the total number of working days between two dates in Excel.  This allow...
Get a Date that is So Many Working Days Before or After a Date in Excel - WORKDAY
Tutorial: How to find a date that is so many days before or after a specified date, excluding weeken...
Years, Months, Days Between two dates in Excel
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
Display Numbers, Dates, & Times in the Correct Format in Excel
Tutorial: In this tutorial I am going to look at Number formatting. Number formatting allows you to ...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course