Power Automate - Calculate Number of Working Day Between two days Excluding Holidays & Weekends

[@mjmann2402]

I ran into dilemma. when the start and end date is the same day. The result of the date difference will be 0 and it errors. Is there a way around this or a fix? Thank you kindly 😃

[@alchimista83]

I'm sorry, but I don't understand your reasoning. If I select from Sunday October 1st till Friday October 6th, the calculation would exclude two days, Sunday and the Monday because is public holiday, so the results should be 4 instead of 3 days. Tuesday, Wednesday, Thrusday and Friday (because the 6th is included in the date range). In your example is like you are excluding Friday.

[@mjmann2402]

This is excellent! Thank you so much 💜

[@kelcieanderson8554]

Perfect. It's exactly what I wanted to do without being too complicated.

[@KuldeepSingh-nq1vi]

Very Nice Video Sir, how can get total hours between two dates excluding weekends.. Please suggest how to achieve it I need it on urgent basis.. ❤

[@alejandroseeik6592]

cool

[@paul4637]

Is there a way to do this with dataverse tables ? We have a bank holiday table in dataverse which we want to use for the bank holiday exclusion dates.

[@Crisis16J]

Awesome technique, just to note that you cannot use negative numbers with Range function.

[@juansebastianmorenomoreno1484]

Muchas gracias mi amigo !!!

[@LernenTech]

@@juansebastianmorenomoreno1484 de nada

[@aishuhr1687]

Nice video, could please tell how to take date difference in share point list

[@LernenTech]

will try

[@NDPCloudSolutions-cm5nj]

Thanks. You saved a life today.😅

[@madhupspk1066]

please refere me if they are any vacanies on power automate and power apps in your company ..i have 1.5 years of experience

[@barunroyghatak4380]

Nice video.

[@emmanuelbazimya2057]

How does he get the "dddd" format?

[@LernenTech]

sorry didn't get your point?