Calculate Days Between Dates Excluding Weekends and Holidays

Edit
Add to Favorites
Author:

[file link below here or in side column]

Question? Ask it in our Excel Forum


Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016
Downloadable Files: Excel File
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...