web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Calculating working da...
Power Automate
Unanswered

Calculating working days between two dates

(1) ShareShare
ReportReport
Posted on by 8

Hello,

I am trying to create a flow that will cycle thought my SharePoint list and find the number of business days between two give date fields  "Date received" and "Date complete" for each entry.  I then want to insert that number into field "Days Needed" for each item.

 

I don't need holidays taken out.

 

 

Example:

"Date received" 1/1/2024 "Date complete" 1/12/2024 Equals 10 Business days.  Update "Days Needed" field with "10" move to next line repeat flow.

 

Any help would be appreciated

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,960 Moderator on at

    hi @JasonM2457 

     

    First hit, of many after typing what you want.. its all over. It would be good to search for them and try them and share what you tried, as we don't like having to write everyones stuff for them. 

     

    My query on Bing - find number of business days between dates in power automate

     

    How to count business days between two dates in Power Automate – Digital Mill

     

    As for the other, please write some of the flow and come back if you are lost.


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

     

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard