Unanswered

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

(2) Share

Report

Posted on by RBoneck

415

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

RBoneck 415 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
timl 36,558 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No