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 TH-cam Course! Create Fillable Forms in Microsoft Word:
• Creating Fillable Form...
__________
CONNECT WITH ME 📎
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
Instagram: / sharonsmithlearn
__________
GEAR
🎙 Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: techsmith.z6rjha.net/NZG5b
📗 Green Screen: amzn.to/2DnHsY2
📸 Camera: amzn.to/39KvpQA
🔌 Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES
✏️ JotForm: www.jotform.com/pricing/?utm_...
📑 Wondershare PDFelement (PDF Editor): bit.ly/31QEkA8
💻 PresenterMedia: shareasale.com/r.cfm?b=417324...
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
Check out my helpful list of templates available for purchase: www.etsy.com/listing/87584666...
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: www.paypal.com/cgi-bin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
✦ Visit mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
PLAYLISTS:
➤ Jotform Tutorials: • Jotform Tutorials
➤Creating Fillable Forms: • How To Create A Fillab...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist

[@fredamn76]

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

[@SharonSmith]

Awesome! Thanks for watching!

[@j.r.61]

YOU ARE AMAZING!!

[@SharonSmith]

Thank you for watching!!

[@oleandra3759]

Great content! Thank you!

[@SharonSmith]

Glad to help! Thanks for watching!

[@suzannesayabuaovong5145]

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.

[@francesdobbins2964]

This was an excellent video!

[@SharonSmith]

Thanks so much, Frances! I'm glad you liked it. Thanks for watching!

[@hassanrozh6579]

Good job, thanks a lot.

[@SharonSmith]

Thanks so much for watching! Glad you found it helpful!

[@silvestrecamposano6317]

Thank you for the techniques....

[@SharonSmith]

Glad to help! Thanks so much for watching and for subscribing to my Channel!

[@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?

[@mohanr8607]

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

[@SharonSmith]

Hello, yes, you would want to use:
=NETWORKDAYS.INTL(start date, end date, 7, [holidays])
Using "7" for the Weekend argument in the NETWORKDAYS.INTL syntax will recognize Friday and Saturday as your weekend days. I hope this helps! Thanks for watching!

[@mohanr8607]

Great. Can you help me with,
Which formula should I use If i need to include weekends and calculate SLA.
Actually, I need to calculate SLA between two dates including weekends. Support hours are 8 AM to 10 PM

[@syedikramullah1114]

Nice

[@SharonSmith]

Thank you! Thanks for watching!

[@SathishKumar-po7ev]

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

[@SharonSmith]

Hello! You can use =WORKDAY.INTL and then the syntax would be:
=WORKDAY.INTL(startdate, days, [weekend], [holidays])
in the argument area for [weekend], but the number 16 - this represents Fridays only as your weekend. The same holds true for the NETWORKDAYS.INTL formula. Hope this helps! Thanks for watching!

[@azstudio9489]

=IF(D4

[@SharonSmith]

I tested with this formula and it is working:
=IF(A2

[@Hey_Delight]

Hey Miss...network days who programmed this?

[@SharonSmith]

Hi there, NETWORKDAYS is a delivered function in Microsoft Excel using M365 version. Hope you found it helpful! Thanks for watching!

[@Hey_Delight]

@@SharonSmith Don't have MS365...but love to try it someday.
I'm a big fan of Excel....and still using 2007 but I love it and the limited functions there...challenging my creativity, math and logic in nesting various applicable functions to build efficient systems helping me with my freelance accounting work.
Thank you for your response.