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

Подписаться 18 тыс.

Просмотров 3,6 тыс.

50% 1

#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.

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 13

@kelcieanderson8554 6 месяцев назад

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

@Crisis16J 3 месяца назад

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

@NDPCloudSolutions-cm5nj 6 месяцев назад

Thanks. You saved a life today.😅

@madhupspk1066 5 месяцев назад

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 9 месяцев назад

Nice video.

@alejandroseeik6592 6 месяцев назад

cool

@paul4637 4 месяца назад

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 4 месяца назад

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

@aishuhr1687 9 месяцев назад

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

@LernenTech 9 месяцев назад

will try

@emmanuelbazimya2057 6 месяцев назад

How does he get the "dddd" format?

@LernenTech 6 месяцев назад

sorry didn't get your point?

@alchimista83 3 месяца назад

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.