Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

Find out how you can quickly calculate the number of any specific day of the week (for example only Fridays) between two specific dates in Microsoft Excel.

⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/count-fridays-file

You can use this technique to count the number of weekends, Mondays, Tuesdays or any day of the week between two dates.

Key Highlights:
▪️ Understanding Date Calculations: Exploring how Excel interprets dates and performs calculations.
▪️ Using NETWORKDAYS.INTL Formula: Learning how to use this formula to exclude specific weekdays, like Fridays.
▪️ Formula Breakdown: Detailed explanation of the formula components and their functions.

The Excel formula is simple: It uses NETWORKDAYS.INTL function to get the answer. The difference between NETWORKDAYS function and the NETWORKDAYS.INTL function is that you can choose which days you'd like excluded. Excel NETWORKDAYS automatically excludes Saturdays and Sundays.

My Online Excel Courses ► https://www.xelplus.com/courses/

LINKS to related videos:
More about Excel NetWorkDays: https://youtu.be/uJKFObU0Dug

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

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: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/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