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

[@LeilaGharani]

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

[@macky2green]

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

[@LeilaGharani]

Thank you, Mark! Great to have you 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.

[@AN-fl6rz]

@Ali Akber … Absolutely !!

[@LeilaGharani]

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

[@karanbirsingh2408]

Use count formula

[@wrwebb9272]

Thanks!

[@LeilaGharani]

Thank you so much!

[@gintomino4136]

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

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

[@IvanCortinas_ES]

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

[@LeilaGharani]

Thank you, Iván!

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

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

[@LuisCarlosChavez717]

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

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

[@custod9944]

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

[@cshahed]

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

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

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

[@ManafKAMIL]

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

[@Nonas63]

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

[@subhashsemwal2000]

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

[@EmperorRoddy]

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

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

[@asadurrahman1681]

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

[@michaelmwanza355]

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

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

[@taizoondean689]

Thanks ma'am your tricks are simply amazing

[@markmcconnell157]

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

[@pramod8105]

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

[@ronvds4713]

1,000,000 is a big number. Congratulations

[@FarhanMerchant]

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

[@LeilaGharani]

Wonderful!

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

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

[@MillersLanguageSchool]

Congratulations! Good job! Thanks for the andvice!

[@Heredia1973]

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

[@LeilaGharani]

Glad you liked it!

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

[@MuhammadShamim-yj6dc]

The best part was 10, appreciated your smart work.

[@jpgo8323]

Thank you for videos like these.

[@ghada2602]

Excellent, always something new to learn.

[@markpodesta4605]

Thank you and congrats Leila on getting 1M subscribers!

[@LeilaGharani]

Thank you! 😃

[@mohammedalmashibi1727]

Thank you Leila, very useful

[@debasmitapothal1642]

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

[@LeilaGharani]

Thank you! 😃

[@EricHartwigExcelConsulting]

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

[@merbouni]

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

[@anilkakade1414]

Thank you and congrats for 1M subscribers!

[@LeilaGharani]

Thank you! 😃

[@mostafa4321]

The bonus trick was awesome Leila Merci :)

[@LeilaGharani]

Thank you! Glad you find it useful.

[@AngelloShongwe]

This is the coolest thing. Thank you.

[@88lolo1]

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

[@LeilaGharani]

You're welcome!

[@billsalalima5009]

THIS IS LIT! Thanks for the learning.

[@TheCAGamer2108]

Very helpful and very well explained, thanks!

[@chrism9037]

Awesome thanks Leila!!

[@LeilaGharani]

You're so welcome, Chris!

[@sameerahmed9674]

Great! Thanks for sharing the trick

[@AlbraaAdam]

thanks for your support.

[@olipeeeeee]

your bonus tip is awesome. 🤯 thank you 🙏

[@better5943]

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

[@LeilaGharani]

Thank you, Paul!

[@HellenofTroy897]

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

[@rodrigovalerio9548]

As always, great video Congrats on the million subscribers!

[@tha2irtalib343]

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

[@LeilaGharani]

My pleasure 😊

[@HenricAndersen]

And once again a great video from you 👍👍👍

[@prashant333kumar]

Many congratulation Miss Leila for Achieve 1 million subscribers..

[@LeilaGharani]

Thank you!

[@Zax0422]

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

[@LeilaGharani]

You are so welcome!

[@rockpads6286]

LOVE THE SHORT VIDEOS THAN THE LONG LENGTHY VIDOES

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

[@grahamwooddesignz]

Very helpful thank you

[@jorgearturomontesdiaz8049]

The Excel Godess ⚘⚘⚘😍😍😍

[@mattschoular8844]

Great...Thanks Leila.

[@balabochur]

Wow so cool. Congratulations on the subs

[@Vince0208]

Love your contents

[@ValerieCudnikCDG]

Thanks. Super helpful!

[@jawedsultani7451]

تشکر از شما همه مشکل ام در این موضوع حل شد

[@VivianCooks]

I love your channel

[@vick7848]

You're amazing. Thank you!

[@mazharansari7797]

Congrats on 1 Million subribers

[@sumanths2230]

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

[@LeilaGharani]

You're welcome 😊

[@camheljhonapugan]

Thank You so much I learned this video

[@karthikeyanm4369]

highly helpful

[@africanqueenmo]

WOWOWOW I just love this thank you

[@vivekdandriyal5971]

Thank you so much !!

[@simplysagar2688]

Dear Leila I enjoyed video and also subscribed your channel🤗🤗🤗

[@LeilaGharani]

Thank you so much!

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

[@vasuvasu-xg4jq]

Very Help full like always 👍

[@LeilaGharani]

Glad to hear that!

[@vasuvasu-xg4jq]

@@LeilaGharani I work at IBM... Happy that I able to watch many of full fledged videos..as IBM collaborated with Udemy.... Thanks a lot for all your efforts in sharing knowledge 👍👍

[@manvendrasolanki]

Very helpful content 👍

[@adityapatnaik6079]

this is legendary stuff !

[@SKAOG21]

Thank you!

[@srikantharra3095]

Wow, Great, and Thanks a lot .

[@vigneshkumar6746]

Thank a lot for 0&1 Newly learning 👍

[@ChawkiARazak]

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

[@rishabhmehta3364]

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

[@alaaaldahi4019]

huge thank you

[@atiqRehman111088]

nice video......thanks it is helpful...

[@SyedUsman]

Pls also see my channel related to excel It has some great and time saving tips Would love your feedback on it.

[@motarikmalek6040]

Very helpful

[@nadermounir8228]

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

[@teem5945]

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

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

[@MrVijay20vijay]

Congratulations 🎇 on 1m subscribes...

[@erick.terrestrial]

Thanks to your videos i got certified, grateful❤

[@LeilaGharani]

Great job!

[@Jalalmaher1983]

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

[@saifalshaqsi7612]

Genius 👌🥰

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

[@koraj1690]

Very useful

[@yogibearstie]

Super. Now I can make the case that a four day workweek wouldn’t be a problem. 😎

[@LeilaGharani]

Exactly! 😁

[@SavageGothamChess]

Million subs! Congrats.

[@LeilaGharani]

Thanks!

[@Ryuzaki2100]

yup

[@FreshSpecimens]

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.