Others

How to Create Business-Day Monthly Events in Power Apps

Elise Williams Oct 1, 2026 868 views

Question details

The user needs to calculate and schedule recurring events on specific business days (e.g., the third business day of the month) in Power Apps calendars.

How to Create Business-Day Monthly Events in Power Apps

Product: Microsoft Power Apps
Device & OS: not provided
Scenario: Scheduling a monthly recurring event while automatically skipping weekends and company holidays.
Observed behavior: Power Apps requires complex custom formulas to calculate business days accurately and integrate them into a SharePoint event list.

Before you start

Ensure you have access to your Microsoft Power Platform environment, connected SharePoint event list, and a separate list of recognized company holidays to reference in your formula.

Solution 1Recommended

Seek Specialized Guidance in the Power Apps Community

Since business day calculations require complex custom logic in Power Apps, the official community is the best place to get tailored formula solutions.

Power Apps does not have a native WORKDAY function out-of-the-box like Excel does. Calculating the third business day of the month requires combining multiple date functions, filtering out weekends (Saturday and Sunday), and cross-referencing a separate data source for holidays.

Visit the Community Forum

Navigate to the official Microsoft Power Apps Community online forum.

Search for Existing Solutions

Use the search bar to look for 'business day calculation formula' or 'recurring monthly events SharePoint list', as many advanced users have previously shared code snippets for this exact scenario.

Post Your Specific Requirements

If you cannot find a matching formula, create a new post detailing your SharePoint event list schema, your holiday data source, and your exact business day requirements.

Seek Specialized Guidance in the Power Apps Community

Use Power Automate as an Alternative: Often, it is easier to handle complex recurring scheduling using a scheduled cloud flow in Power Automate rather than building the calculation directly inside a Power Apps canvas app.

Free Microsoft Office alternative

Use WPS Spreadsheet for Effortless Business Day Calculations

While Power Apps requires custom coding for business days, WPS Spreadsheet manages this effortlessly. If you need to track schedules, project timelines, or recurring events, try WPS Office as a free, lightweight, and highly compatible alternative to Microsoft Office.

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 create a new Spreadsheet, or open your existing Excel project timeline.
3. Use the WORKDAY Function: Simply type =WORKDAY(start_date, days, [holidays]) into a cell to automatically calculate your recurring business-day events without any complex coding.

Fully compatible with Microsoft Excel (.xlsx) formats and formulasBuilt-in WORKDAY and NETWORKDAYS functions to instantly calculate business daysFree to use, lightweight, and fast to install on any deviceIntuitive tabbed interface for seamless document management

microsoft office alternative - wps office

Frequently Asked Questions

Does Power Apps have a built-in function to calculate business days?

No, Power Apps lacks a native equivalent to Excel's WORKDAY function. You must manually calculate business days using the Weekday() function to identify and exclude Saturdays and Sundays.

How can I exclude holidays from my Power Apps calendar events?

You need to create a dedicated data source, such as a SharePoint list or Dataverse table, that contains all company holiday dates. Your formula must then check this list and subtract matching dates from your total business day count.

Is it better to use Power Automate for recurring business events?

Yes. Power Automate features robust recurring triggers and easier date manipulation tools, making it much simpler to generate monthly business-day events and push them to a SharePoint list than calculating them inside the Power Apps UI.

Office Quick Solutions