Calculate Number of Workdays between Two Dates excluding Weekends & Holidays

Calculate Number of Workdays between two dates, excluding Weekends and Holidays, using the NETWORKDAYS.INTL function

Ask Your Excel Question #10

Microsoft's Help:
NETWORKDAYS.INTL

NETWORKDAYS

-~-~~-~~~-~~-~-
-~-~~-~~~-~~-~-

[widywijaya]

my job become much more simple..., thanks. the explanation was so clear & easy..

[bilalhameed]

Thank you so much for your support through this video.

[maggieng]

Hi, i want to add this function in a chart. That chart includes tasks for different countries so every country has different holiday calendar. There is another cell to indicate that task is for which country. Then how can i modify this function to consider that cell and choose the correct list of holiday?

[samesamea]

Thanks for the video, Buddy! Very helpful!

[UZNCO]

In your table of holidays can you have date ranges rather than just one day? For example I need to calculate the cost of transport for a child using it 2 days a week so I can use the string formula for that. But I have to take of School Holidays and half term breaks. Or is there an even better way to do that?

[AshokKumar-guqg]

How two calculate th number of day if for one employee contract 26 day in a month and other having 28 days in a month and few having 30 days in a month between two dates

[thulasiprasad]

Sir when ever your typing something in formula bar please zoom it then it will seen