Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Adding a number of business days to a date; exclude weekends (DateAdd vs BusinessDaysAdd)

(2) ShareShare
ReportReport
Posted on by 407

Currently in PowerApps, if you want to add business days to or from a date you have to get creative with the DateAdd and Weekday functions.

It would be very helpful to have the Workday function from Excel available in PowerApps. (https://exceljet.net/formula/add-business-days-to-date). The Excel function even has the option to skip holidays as well, though I would be plenty happy without that feature.

Is this something that can be added?

  • RBoneck Profile Picture
    RBoneck 407 on at
    Re: Adding a number of business days to a date; exclude weekends (DateAdd vs BusinessDaysAdd)

    Whoops, I meant to post this as an idea. I must have also searched in the wrong place to see if it was already an idea. Thank you for the link!

  • timl Profile Picture
    timl 34,352 on at
    Re: Adding a number of business days to a date; exclude weekends (DateAdd vs BusinessDaysAdd)

    Hi @Boneckrh19 

    I also agree that there should be an implementation of the Workday function and I've added a feature request in the ideas forum. You can vote for this idea through the link beneath.

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Provide-a-function-to-add-or-subtract-working-days-excluding/idi-p/789366

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard