cancel
Showing results for 
Search instead for 
Did you mean: 

Provide a function to add or subtract working days (excluding weekends and public holidays)

Microsoft Excel provides a function called WORKDAY

 

This function enables us to add or subtract working days (excluding Saturdays or Sundays), and can optionally take into account a list of public holidays.

 

There is often the need to perform calculations based on working days, and the workarounds that we need to use are convoluted.

 

My suggestion is to provide an implementation of the Excel WORKDAY function in Power Apps.

The usage details of the Workday function is shown beneath:

https://support.microsoft.com/en-us/office/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33

 

---------------------------------------------------------------------------

WORKDAY(start_date, days, [holidays])

The WORKDAY function syntax has the following arguments:

  • Start_date    Required. A date that represents the start date.

  • Days    Required. The number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.

  • Holidays    Optional. An optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contain the dates or an array constant of the serial numbers that represent the dates.

Status: New