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

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.

🔎 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.

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:

🚩Let’s connect on social:

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

[mackygreen]

*Congratulations on 1 MILLION subscribers, Leila! **_You're the best! Proud to be here._*

[aliakberza]

I cannot even count the number of times these videos have helped me out when I am stuck. Best part is that you learn 10 other things alongside the topic of the video! This is amazing, thank you so much for all your work.

[gintomino]

You deserve a million subscribers. You have changed so many lives thank you!

[hatimalhaj]

I’m using this since long time, but just I knew it’s possible to represent working days in 0&1, always their is something to learn from you. Thanks for sharing.

[cshahed]

Thanks. Using Execl and you make it more enjoyable 😀

[samehsafwat]

FINALLY 😁
i was searching for excluding more than 2 days per week and you are the only person who shared this trick.

thank you very very much, how did you know this, couldn't find it anywhere.

[TAMTSZFUNG]

Are you literally Goddess? You never cease to amaze people. I thought VBA is the only option to customise weekends and here you come!

[aakashshanavas]

Thank you so much, with the taking control of days section using 1s and 0s, you helped me solve a major problem I was facing for days 🙂

[mydigitalquill]

You've earned my like for the video. Not only have you presented it with quality - the clarity in the content has left no questions for me to ask!!

[vijayarjunwadkar]

Yet another useful video, liked the idea of 1s and 0s in the function, didn't knew it! Leila, you never fail to surprise with something new and novel in each of your video! We are blessed to have you as our teacher! 😊👍

[mahmoodahmed]

Hi Leila,
I am actually waiting for this day. Today you have achieved 1 million subscribers. Congratulations.
I am a great fan of you & your channel for a long time and like your tutorials. You are doing fantastic. Keep going on. My good wishes are always with you. 👍👍👍

[custod]

No where else will yu learn about this 0 and 1 trick. Very useful. Thank you Madame.

[carlwilson]

Thank you!! I wanted to exclude Sundays in lapsed days and this is the only tutorial I found that got it right. Every other one just removed one day per week which is useless when only calculating a few days that may or may not cross a weekend.

[atulbharti]

hats off the way you teach excel.Amazing👌 I am excel user but ur videos makes me excel expert in my office.thank you mam

[Barbie.]

So another useful trick that I didn’t know I needed until you showed me. Already have 3 different uses on reports I have. Thank you!

[LuisCarlosChavez]

Outstanding as always, Teacher Lelila. I've never seen this trick before. Thanks a lot.

[merbouni]

Well, I think someone learned something new today..😍

[IvanCortinas_ES]

Excellent tutorial Leila. Congratulations!! 1M Thanks!!!

[subhashsemwal]

Leila Gharani, Many Many congratulations for 1M family.
I am also feeling proud being a family member of your

[Nonas]

Brilliant, Leila. Especially the mini-calendar! Little & easy things which make life much easier. Very much appreciated!