How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too) скачать в хорошем качестве

How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too)

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... In this video you'll learn how to calculate days between a start and an end date in Microsoft Excel excluding days that should not count like weekends or other holidays. This way you can easily calculate the difference between two dates. We'll have a look at the difference between the NETWORKDAYS and the NETWORKDAYS.INTL function in Excel. I'll also show you a bonus trick you can use to get full flexibility on which working days you want to include or exclude in your calculation. For example, only count certain working days in a week like Monday, Tuesday, and Saturday. This is a hidden Excel tip not many people know - not even advanced Excel users. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/count-days-... 🔎 What You'll Learn: Basic Date Differences: Understand how to calculate the total number of days between dates using simple Excel formulas. Excluding Weekends: Explore the NETWORKDAYS function to exclude typical weekends (Saturday and Sunday) from your calculations. Adding Holidays: Learn to refine your calculations by incorporating public holidays into the NETWORKDAYS formula. Custom Weekends and Workdays: Delve into the NETWORKDAYS.INTL function to customize weekend days or define specific non-working days tailored to your schedule. Dynamic Arrays for Calendar Creation: Bonus content on creating dynamic Excel calendars using Office 365's powerful functions. 📈 Key Takeaways: Flexibility: Tailor your workday calculations to suit any work schedule, whether standard or unconventional. Efficiency: Streamline your date-related analyses, from project timelines to attendance tracking. Practical Skills: Gain valuable Excel knowledge applicable in various professional contexts. ★★★ My Online Excel Courses ► https://www.xelplus.com/courses/ 00:00 How to Calculate Workdays Between Dates 00:30 Calculate Days Between Dates 01:17 Calculate Working Days excluding Weekends and Holidays 04:28 Bonus: Calculate Days Between Days with Defined Working Days 07:02 Wrap Up LINKS to related videos: ► Dynamic Calendar:    • Create Easy Yearly Calendar in Excel ...   ► 5 Excel Functions YOU NEED in 2021:    • 5 Excel Functions EVERYONE Needs   ➡️ Join this channel to get access to perks:    / @leilagharani   👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram:   / lgharani   LinkedIn:   / xelplus   Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel