Excel Magic Trick 535: Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTL

Download Files:
people.highlin...
See how to use NETWORKDAYS NETWORKDAYS.INTL WEEKDAY ROW INDIRECT and SUMPRODUCT functions to count weekdays including half (1/2) workdays.
See Excel 2010 New Functions

[@excelisfun]

You are welcome! Thanks for the 5 stars!

[@soklamon]

Thank you!

[@excelisfun]

You are welcome!

[@Ivan-ee5tl]

Hi, it look's to me that formula for half day won't work correctly if e.g. Saturday is holiday. It doesn't take into account that Saturday could be holiday hence should be value 0 instead od 0,5. Please correct me if I'm wrong. Thnx

[@cphilip98]

Instead of counting elapsed time in days including half day on Saturday, what would be the formula to count it in hours?

[@chymi2801]

What if I need to count some Holidays as half days? Is it possible?

[@navinishart5199]

and how can we change .5 days in 1 day in excel

[@navinishart5199]

I am ausing the following formula =WORKDAY(C10,E10,'Esri Holidays'!B2:B20) where in E10 I enter days. The promblem is excel 0.5 days as 1 day and I cannot enter 0.5 days in E10. Why excel considers .5 day as 1 day