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 / Days Difference using ...
Power Automate
Unanswered

Days Difference using PowerAutomate

(0) ShareShare
ReportReport
Posted on by 5

Hi Team,

 

I would like to calculate elapsed days using PowerAutomate excluding weekends.

 

I have a column called SubmitDate in SharePoint. Elapsed Days should be Today - SubmitDate excluding weekends.

 

@ScottShearer

 

Thank you. 

Categories:
I have the same question (0)
  • v-litu-msft Profile Picture
    on at

    Hi @MJS,

     

    You could following these steps to approach that:

    1. Initialize several variables to store Today, submit day, and count days.

    2. Create a Do until action to count days, if today does not equal to the weekend, add 1 day based on the count days variable, or do nothing. For each run, we should add 1 day to the Today variable.

    dayOfWeek(variables('Today'))

     

    Screenshot 2021-02-10 114142.jpg

     

    Screenshot 2021-02-10 114210.jpg

     

    Screenshot 2021-02-10 114224.jpg

     

    PS: The default looping limits is 60, we could set it to 5000 to make it could count 5000 days difference.

    Screenshot 2021-02-10 114508.jpg

     

    I export the Flow and upload it, you could click the zip file under the post and import it into your Flows to test it. 

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MJS Profile Picture
    5 on at

    Thanks for the response. SubmitDate can not be greater than Today! Its a past date.

     

    Thank you.

  • MJS Profile Picture
    5 on at

    Any help would be appreciated.

     

    @ScottShearer 

  • Verified answer
    v-litu-msft Profile Picture
    on at

    Hi @MJS,

     

    OK. I modified my Flow, set the summit day less than today, and logic has been modified.

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard