Рет қаралды 15,245
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 KZbin 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