Calculate Working Days Between Two Dates in Excel (excluding Weekend & Holidays)

[@sasikumar1133]

Exclude only 2nd and 4th Saturday in Start date to end date

[@puneetvij8433]

Sumit Sir, The video was very informative and your trend 'excel in 2 minutes' is a very good one, time savvy! ; )

[@excelforeveryone2657]

Good one

[@rishikapatel1619]

When I match days calculated by formula with the manually calculated days by calender that not match with the days calculated by the formula Like my start day is 02 Jan 2021 & end date is 29 Jan 2021 pls calculate the working days between these two dates.nd how can we include end date in the formula I want days including start date nd end date Pls solve my pblm

[@KrisMcCracken]

Fantastic advice. Wonderfully explained and it works a treat!

[@cattac6561]

If I only work on holiday, how to calculate the numbers of work day in given Star and end date😢

[@soumiamoujane3695]

What's the formula to calculate number of bank holidays in a month?.

[@ICCY22]

Thanks alot, this helped me greatly

[@AbhishekMishra-cr1tz]

Very nice formula

[@waleedaljuhaishe7591]

The options after choosing the non working days is not showing

[@ericazg]

Excellent video! So straightforward. How would you enter weekends if I have every other Friday off? I've added them as holidays which works well but wondering if there is an easier/better way?

[@sudipasaha8747]

Very nice very nice

[@alyannadarza4728]

What if you want to include the end date?

[@akashdeshmukh116]

From where I can download the excel file?

[@langproffeducationcenter6874]

How can I Calculate if my 1st, 3rd and 5th Saturdays are Non Working days including Sundays and 2nd & 4th Saturdays are working? please advise!

[@antunmekhail1327]

how to calculate up to today()?

[@andraspeter5721]

Thank you! It is very usefull! There i found one of the best shortcut:F4 or Fn+F4...absolutely extraordinar! Thank you! Have a nice day!

[@JoseViniciusGSilva]

My friend, is there a way to identify how many working days i have on all months? for example, i have a project starting at 01/01/2021 and finishing at 01/04/2021, i need to know how many working days i have on january, february and march but in a large scale, is this possible?

[@sreejondey1917]

SUPER ...

[@GurdeepSingh-hj2qd]

Hi sir Thanx for all videos, Plz let us now how to calculate leave days from joining date to annual leave starting date. (as per less then 5 years into 21 days and more then 5 years to 10 years 28 days.

[@xafridi1]

Thanks 👍 Bro

[@Raji0818]

Amazing 😍

[@nareshreddy8521]

not working

[@michaelpeinado1834]

I am finding your videos helpful but I am working off Excel 2013 but my figures are not coming out correctly. Please help with Birthday, Age and number of days.

[@miguelangelrivera447]

Gracias

[@Pavankumar-dp4dx]

cool

[@kapilbinotra3887]

I want video two days year and days excluding Saturday Sunday

[@kapilbinotra3887]

Two dates

[@Ahmed-fq6si]

I wonder why this guy still hasn't more than 1 million subscribers.

[@abeerali6949]

Zabardast

[@MrGulsaeed]

Hi Sumit in a scenario where each row has different days off then how would I calculate records without typing formula in each row?

[@ski_info]

Amazing

[@hariprasad289]

Awesome

[@shahid36]

What if the holiday date is in the future. Will it automatically accommodate it and not count it?

[@muzaffarsiddiqui]

Thanks, excellent information. I want one more tip, for example, if I am defining country name with each date and want to dynamically look at the holiday's list where information is populated as country and holiday date, the country will be repeated with each holiday. There will be more than 3 countries on the holiday list. Can you make a video on that or let me know what formula will be? Thanks in advance for your help.

[@Theknowledgehub2432]

Nice👍👍 If someone did work an hour then How we can do?makes us video,sir.

[@mandoossee]

if cell b empty then today else calculate workdays between cell A B

[@pasongsinkhamchan1033]

How to calculate when I have half-day work on Saturday? so 5.5 days per week

[@rubykarim1689]

Very clear explanations, clear video and graphs. Thank you!

[@marandawatanabe6250]

You’re the best at explaining this!!!! Thank you!

[@ritchelsatorre365]

if i have to start the first day as day zero how am i going to count the days between 2 dates leaving weekends?

[@Quijanos1]

Well done my friend! This was helpful.

[@dominicrivera5651]

thank you, you helped us very much!

[@myyoutubehandle-rr]

Thanks you so much. This is really helpful.

[@annadominique3225]

Works like magic! Thank you!

[@smitataniwade5623]

It was grt and explanatory

[@RT-ij6cs]

Super Bro Thanks a lot

[@yogeshkhanna5173]

Very useful video sa ave my day

[@bns5392]

Ur writing words not able to see video

[@kanojiyaakhilesh9698]

This was awesome Sumit

[@alexanderpruger5337]

Thanks for the subtitles! Something different.

[@EduardoGarcia-pc7go]

congratulations !!!! good job!

[@yutpheakdey4466]

Great video,thanks

[@Bhimpdl]

Thanks, very useful.

[@rajeshkumarsharma4752]

Beautifully explained.

[@vikaskulkarni4028]

Excellent Video

[@roxannejohnson3940]

This one is very useful. Good to know!

[@oddnumber8149]

ATTACH THE DATA

[@lievenquidousse9074]

Great Formula. Helped a lot! Thanks Sumit !

[@trumpexcel]

Glad you found it helpful

[@apn6824]

Very useful...

[@manoharanduraisamy284]

Thanks Sir

[@BenLinfordUK]

Spectacular!

[@uzondulawrence5134]

Thanks ... helped alot

[@trumpexcel]

Glad you found it useful