Others

How to Calculate a Business-Day Due Date in Power Apps

WPS Editor Oct 7, 2026 869 views

Question details

The user needs to calculate a due date that strictly counts business days, automatically excluding weekends and specific holidays.

How to Calculate a Business-Day Due Date in Power Apps

Product: Microsoft Power Apps
Device & OS: not provided
Scenario: Setting up an automated workflow or custom application that requires accurate deadline calculations based strictly on working days.
Observed behavior: The standard DateAdd function adds calendar days rather than business days, causing calculated due dates to incorrectly fall on weekends.

Before you start

Before building your custom formula, ensure you have created a data source or list containing your organization's official holiday dates so they can be accurately excluded.

Solution 1Recommended

Use Custom Business-Day Logic from the Power Apps Community

Since Power Apps does not have a native WORKDAY function, you must implement a custom logic formula to skip weekends and holidays. The Microsoft Power Apps Community provides excellent templates for this.

Microsoft Power Apps requires combining multiple functions like DateAdd, Weekday, and Filter to accurately calculate business days. Community specialists frequently share proven formula templates that handle these complex date mathematics.

Visit the Power Apps Community Forums

Open your web browser and navigate to the official Microsoft Power Apps Community page to access expert-driven solutions.

Search for Workday Formulas

Use the search bar to query terms like 'calculate business days' or 'exclude weekends DateAdd' to find existing formula templates tailored to your needs.

Implement the Conditional Logic

Copy a suitable formula (which typically uses the Weekday function to check for Saturdays and Sundays) and adapt it into your app's text box or variable.

Connect Your Holiday Data Source

Modify the community formula to reference your specific SharePoint list or Excel table containing official holidays, using a CountIf or Filter function to subtract those days.

Use Custom Business-Day Logic from the Power Apps Community

Formula Complexity: Depending on the number of days you are adding, the formula might require iterative logic or Power Automate flows to calculate accurately over long periods.

Free Microsoft Office alternative

Track Deadlines and Due Dates Easily with WPS Office

While complex app building in Power Apps requires convoluted custom formulas to skip weekends, tracking project deadlines is incredibly simple in WPS Spreadsheet using the built-in WORKDAY function. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office, perfect for managing timelines without writing code.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Open WPS Spreadsheet: Launch the application and open your project timeline or create a new blank workbook.
3. Use the WORKDAY Function: Select a cell and type '=WORKDAY(start_date, days, [holidays])' to instantly generate a due date that perfectly excludes weekends and holidays.

Instantly calculate business days using the built-in WORKDAY and NETWORKDAYS functions without complex coding.Fully compatible with Microsoft Excel (.xlsx) formats, ensuring your existing project trackers open flawlessly.Lightweight software that runs smoothly on all devices without heavy system resource consumption.Familiar spreadsheet user interface makes transitioning your workflow completely seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the DateAdd function include weekends by default?

The DateAdd function is fundamentally designed to add total calendar days to a specified date. It does not inherently distinguish between working days and weekends.

Can I use Excel functions like WORKDAY directly in Power Apps?

No, Power Apps does not natively support the exact WORKDAY function found in spreadsheet software. You must construct custom logic using the Weekday function, or utilize a Power Automate flow to process the date calculation in Excel.

How do I exclude specific holidays in my Power Apps date calculation?

To exclude holidays, you need to maintain a separate data source (such as a SharePoint list) containing your holiday dates. You then use a Filter or CountIf function within your main formula to count how many holidays fall within your date range and adjust the final due date accordingly.

Office Quick Solutions