How to Calculate Working Days in Excel & Exclude Weekends & Holidays

In this Excel tutorial, you'll learn how to calculate the actual working days between a start and end date while excluding weekends and holidays. We'll cover how to use NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAYS in Excel. With NETWORKDAYS, we can easily calculate benefit accruals or eligibility based on actual days worked in a period of time, and ONLY consider the days that should count. You'll learn how to exclude weekends (even if weekends are not Saturday/Sunday) and holidays, and also learn a special way to only count days worked (like only Monday, Wednesday, Friday, if applicable). Then we'll take a look at the WORKDAYS function that allows us to easily calculate a date that is before or after a starting date based on the number of working days. This is useful if you are calculating invoice due dates based on project hours, or expected delivery times, or even the end of a probationary period.

#msexcel #exceltips #exceltutorial #shopwithyoutube

00:00 Calculate Working Days in Excel
00:28 How To Use NETWORKDAYS in Excel
03:00 How To Use NETWORKDAYS.INTL in Excel
04:40 How To Count Partial Workweeks in Excel
06:40 How To Use WORKDAY in Excel

📺 Check out my New YouTube Course! Create Fillable Forms in Microsoft Word:
__________
CONNECT WITH ME 📎
__________
GEAR

RESOURCES

Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
__________
FREE DOWNLOADS
__________
PLAYLISTS:

[fredamn]

Thank you so much! My formula is now correct. I needed to count the first day and with -1 it now works!

[suzannesayabuaovong]

Thank you!! Yes, you are amazing, and very much appreciated. Can you do a video on how to create a formula for calculating leave entitlements allotted, incorporating time used, and displaying entitlements remaining for PDL, fmla, pfl, and cfra? Just curious if this is possible. I’m currently doing this manually.

[laurenashley]

Is there a way to count the number of days to a targeted end date, then have the formula stop counting after an actual implemented date is entered in a separate column?

[mohanr]

Thank you., I am working for middle East project . I need to exclude Friday and Saturday as weekends. Can you help me with the formula

[ladydemando]

Say I want to do this, but take it a step farther? I am using this formula to figure how many days it takes us to to get a quote out to clients--so for example--a client sends us a quote request on Monday, and we get it to them Wednesday--we don't want to count Monday--just Tuesday and Wednesday--how do I do that?

[Hey_Delight]

Hey Miss...network days who programmed this?

[SathishKumar-poev]

Hi madam, in WORKDAY function how to set Only friday as weekend. Excel default take sunday, saturday as week off.. But i need to exclude only Fridays

[azstudio]

=IF(D4<0, ''EXPIRED'', IF(C4<=30, ''EXPIRING SOON'', ''ON TIME'')) can't make it the status... why?

[arabianknight]

Thanks, but unfortunately this did not answer the question which it said it was going to cover in terms of calculating the total number of hours in excess of 24 hours, which is what I wanted to know.