web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Excluding weekend from...

Power Automate

Unanswered

Excluding weekend from date range

(0) Share

Report

Report

Posted on by Filistyn

290

Hey! I want to calculate, how many days are in the range. I have this formula:

add(sub(dayOfYear(item()?['end']),dayOfYear(item()?['start'])),1)

Which works perfectly, but I need to exclude weekends from it. Could someone help?

Thanks!

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report
See the following posts for guidance:
Calculating working days in Power Automate
https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Calculating-working-days-in-Power-Automate/ba-p/557278
And Calculating working days in Power Automate or Logic Apps
https://www.chorus.co/resources/news/calculating-working-days-in-power-automate-or-logic-apps
Ellis

Was this reply helpful? Yes No

Join the conversation