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

Join 400,000+ professionals in our courses here 👉 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: 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 ► 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 Cal...
► 5 Excel Functions YOU NEED in 2021: • 5 Excel Functions EVER...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: 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

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/count-days-file

[@Nonas63]

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

[@mydigitalquill8945]

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! 😊👍

[@LeilaGharani]

Thanks for your support, Vijay! I always enjoy your comments.

[@macky2green]

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

[@LeilaGharani]

Thank you, Mark! Great to have you here 😊

[@gintomino4136]

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

[@carlwilson2311]

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.

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

[@AN-fl6rz]

@Ali Akber … Absolutely !!

[@LeilaGharani]

Thank you so much! I'm very glad to hear that.

[@karanbirsingh2408]

Use count formula

[@LuisCarlosChavez717]

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

[@rishabhmehta3364]

Wow. Thank you so much for creating such informative and high quality content!☺️

[@hatimalhaj7792]

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.

[@zaydarendse2812]

Wonder if 0&1, will work with an array of time too...

[@LeilaGharani]

My pleasure!

[@ManafKAMIL]

Great tutorial.... Almost everything in this video was new to me! Thank you

[@teoxengineer]

Leila, 👀 I am in shock again. It was an incredible technique. Knowing how to use it will be very useful, especially for those in the financial sector and planners. Thanks, Leila for this useful bonus. Again, a special request, can you prepare an educational video on hour-minute-second calculations in Excel and their effects on day and week calculations? I would be very happy.

[@EmperorRoddy]

Leila, you are brilliant and your knowledge and content shared is so so so useful and eye-opening. Thank you.

[@Barbie.7884]

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!

[@LeilaGharani]

Great to hear!

[@aakashshanavas8437]

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 🙂

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

[@HellenofTroy897]

You're really good at this Leila. Kudos!!

[@IvanCortinas_ES]

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

[@LeilaGharani]

Thank you, Iván!

[@cshahed]

Thanks. Using Execl ''0000000'' and you make it more enjoyable 😀

[@EricHartwigConsulting]

Seriously awesome video! Thank you for creating/sharing this!

[@asadurrahman1681]

new to excel: love your videos, on point and informative.

[@samehsafwat2657]

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.

[@samehsafwat2657]

ehm, never mind, I found it in the help of excel, go to "formulas" tab and select the networkdays formula then "help on this function" on the bottom of the pop up window. but thank you anyways

[@michaelmwanza355]

Thanks a million.You've really helped grow.You the best.

[@pramod8105]

Congratulations on 1 million subs Leila. You are doing great help...you deserve more subs. Thanks for all the videos.

[@olipeeeeee]

your bonus tip is awesome. 🤯 thank you 🙏

[@markmcconnell157]

I love you! Your channel is the BEST!!!

[@atulbharti7880]

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

[@FarhanMerchant]

Great insights ; adding holidays so simply is something new I learnt today ; Many Thanks !!

[@LeilaGharani]

Wonderful!

[@taizoondean689]

Thanks ma'am your tricks are simply amazing

[@custod9944]

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

[@jpgo8323]

Thank you for videos like these.

[@MillersLanguageSchool]

Congratulations! Good job! Thanks for the andvice!

[@ValerieCudnikCDG]

Thanks. Super helpful!

[@ghada2602]

Excellent, always something new to learn.

[@merbouni]

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

[@billsalalima5009]

THIS IS LIT! Thanks for the learning.

[@Zax0422]

Wow! There’s so much to learn THANK YOU 🙏

[@LeilaGharani]

You are so welcome!

[@xloneclick]

Many thanks always for so clear explanation👍

[@zionovic2128]

Great video, I always have something to learn from your channel. I have a question: can you please do a video about how to find day, month, and year difference between two dates. Basically another way to do what DATEDIF function does. I am aware that DATEDIF function is deprecated because it bugs/error when computing some dates.

[@subhashsemwal2000]

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

[@Heredia1973]

Hi Leila! Your are the best! Thank you so much for this video!!

[@LeilaGharani]

Glad you liked it!

[@user-fm7rf7mo1b]

thanks for your support.

[@MuhammadShamim-yj6dc]

The best part was 10, appreciated your smart work.

[@africanqueenmo]

WOWOWOW I just love this thank you

[@kcjaishankar]

Congratulation on 1M subscribers. Your each video has something to learn. Soo easy to understand the way you explaining things. Thanks alot for all the videos you posted and for those tips in your bag which you gonna post in coming days..

[@LeilaGharani]

Thank you so much 😀

[@nadermounir8228]

Great video and great tips about to contribute the number of days off 👌

[@HenricAndersen]

And once again a great video from you 👍👍👍

[@camheljhonapugan]

Thank You so much I learned this video

[@sameerahmed9674]

Great! Thanks for sharing the trick

[@markpodesta4605]

Thank you and congrats Leila on getting 1M subscribers!

[@LeilaGharani]

Thank you! 😃

[@sahunitin85]

Very helpful and very well explained, thanks!

[@mahmoodahmed5305]

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

[@LeilaGharani]

Thank you! 😃

[@mahmoodahmed5305]

@@LeilaGharani , My pleasure. Waiting for your next video. Thanks.

[@mohammedalmashibi1727]

Thank you Leila, very useful

[@tha2irtalib343]

Perfect....always perfect , thanks for sharing.

[@LeilaGharani]

My pleasure 😊

[@vick7848]

You're amazing. Thank you!

[@mostafa4321]

The bonus trick was awesome Leila Merci :)

[@LeilaGharani]

Thank you! Glad you find it useful.

[@teem5945]

Geez! I've tried other creative means. Wish I knew this earlier. Thank you very much!

[@grahamwooddesignz]

Very helpful thank you

[@AngelloShongwe]

This is the coolest thing. Thank you.

[@Vince0208]

Love your contents

[@vigneshkumar6746]

Thank a lot for 0&1 Newly learning 👍

[@88lolo1]

Thank you so much, this is gold, I was unable to exclude weekends until I saw this video.

[@LeilaGharani]

You're welcome!

[@vivekdandriyal5971]

Thank you so much !!

[@chrism9037]

Awesome thanks Leila!!

[@LeilaGharani]

You're so welcome, Chris!

[@better5943]

Happy 1M Subs, congrats! and thank you for the useful contents

[@LeilaGharani]

Thank you, Paul!

[@SKAOG21]

Thank you!

[@balabochur]

Wow so cool. Congratulations on the subs

[@rodrigovalerio9548]

As always, great video Congrats on the million subscribers!

[@daveh4208]

Ms. Gharani, you are a savior, I have been looking for hours to find this formula to calculate the number of days we've been working on a task in a project from the start date to the current date. I ended up using =networkdays.intl(a2,today(),1,$O4:$O6). I then used some cell formatting to change any negative numbers to 0 for tasks that haven't started yet. Hopefully when I refresh tomorrow everything will update. Even if it doesn't you've gotten me a lot further then any of the other excel wizards on youtube.

[@prof.code-dude2750]

Thanks for this tutorial..... I cannot use it right now but knowing how to do these simple tasks in Excel is a benefit for school work thanks a lot 🔥🔥🙏🙏

[@Ryuzaki2100]

yes

[@LeilaGharani]

Glad to hear that!

[@srikantharra3095]

Wow, Great, and Thanks a lot .

[@alaaaldahi4019]

huge thank you

[@manvendrasolanki]

Very helpful content 👍

[@anilkakade5793]

Thank you and congrats for 1M subscribers!

[@LeilaGharani]

Thank you! 😃

[@VivianCooks]

I love your channel

[@adityapatnaik6079]

this is legendary stuff !

[@debasmitapothal1642]

Congrats! You have 1 MILLION SUBSCRIBERS! & Thanks for this video!

[@LeilaGharani]

Thank you! 😃

[@mattschoular8844]

Great...Thanks Leila.

[@motarikmalek6040]

Very helpful

[@bcfieldtechnician8732]

I always watch your posts, so easy to understand and follow along, really appreciate it!! I've learned a LOT watching them :) I searched your channel but couldn't find anything on a formula for calculating future Statutory holidays in Excel, did I miss that? I have a couple that are VERY difficult for any calendar... Victoria Day in Canada - the last Monday preceding May 25!! Any idea on things like this?

[@asimali5820]

Amazing!

[@mazenalsakkaf]

😲 amazing!

[@Franceskineos]

Great tutorial, may I add a little trick I use when need an easy logical test to check if a day is a workday or not. Just call those functions on the same day both in start and end date; in case of working day it return 1 and in the other case return 0.

[@ronvds4713]

1,000,000 is a big number. Congratulations

[@sumanths2230]

Hi1 It was helpful.Thanks.Keep the good work going.

[@LeilaGharani]

You're welcome 😊

[@karhukivi]

Excellent as always, Leila! What I usually need to count are the minutes between two dates and times for scientific experiments and I have a method for doing it, but I'm wondering if there is a more clever or elegant way to do it?

[@ChawkiARazak]

أحسن الله إليكم

[@vipinpathak6619]

Amazing!!

[@rockpads6286]

LOVE THE SHORT VIDEOS THAN THE LONG LENGTHY VIDOES

[@erick.terrestrial]

Thanks to your videos i got certified, grateful❤

[@LeilaGharani]

Great job!

[@joshuaanande4640]

Very useful

[@spongeesponge9623]

Amazing ...lesson about PERT CPM and Precedence Diagram Method using excel please

[@daughterofolaf]

Um. Okay. I have been trying to figure out how to calculate holidays into a spreadsheet with thousands of date entries for WEEKS without the formula shifting with each cell. Nowhere could I find this function-not on any site, even Microsoft. And here it is in your video not even halfway through. I knew it had to exist. THANK YOU.

[@jorgearturomontesdiaz8049]

The Excel Godess ⚘⚘⚘😍😍😍

[@samiijsph87]

As always learned something new. I wonder is it possible to learn everything about Excel?

[@LeilaGharani]

I doubt it… I’m still learning.

[@vishnupp5944]

Your videos have been very helpful in my professional life. Thank you so much for that. Learned advanced excel and VBA from your videos. Could you please tell me, which is the programming language can be learned to have a good exposure to Analyst profession.

[@SyedUsman]

Python & R

[@rjext1814]

Awesome.

[@mazharansari7797]

Congrats on 1 Million subribers

[@Jalalmaher1983]

If there was a Grammy for Excel, you should win in all categories Laila, Shukran!