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

Notifications

Announcements

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,047 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard