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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,629)