cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Boneckrh19
Kudo Kingpin
Kudo Kingpin

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

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?

2 REPLIES 2
timl
Super User
Super User

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-d...

 

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!

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,605)