Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Pro Dev & ISV
Unanswered

How to add workday in Microsoft Lists formula calculation

(0) ShareShare
ReportReport
Posted on by
Hello everyone, 
 
Is there a way to include WORKDAY() function on the formula in Microsoft Lists? I want it to count the days based on work days only.

The way I do today is not practical because I'm using Power Automate to calculate in excel first. So I'm wondering how can I over pass this workaround and using calculation based on Microsoft List only.
I need to calculate multiple days, so a standard formula won't work.
 
thanks!
  • WarrenBelz Profile Picture
    148,805 Most Valuable Professional on at
    How to add workday in Microsoft Lists formula calculation
    It is possible in Power Apps - this video should assist. If you want is all done in SharePoint (Lists), it may be better posted on the SharePoint Community
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn    Buy me a coffee

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1