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

#datedifference #powerautomate
I this video you will learn how to calulate no of working days between two dates and exclude weekends and Public Holidays. i have used sharepoint list as public holiday source you can use anything you like and can create your own system. this method will help you in sla calculation and other important stuff. I hope you will enjoy it.

[@kelcieanderson8554]

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

[@Crisis16J]

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

[@barunroyghatak4380]

Nice video.

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

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

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

[@alejandroseeik6592]

cool

[@aishuhr1687]

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

[@LernenTech]

will try

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

[@emmanuelbazimya2057]

How does he get the "dddd" format?

[@LernenTech]

sorry didn't get your point?