How to retrieve the number of business days within a specified period.(Power Automate Cloud flows)

Japanese version.

Steps

Power Automate alone is too much work, so we will utilize an Excel sheet.

First, prepare a "Holidays" sheet in an Excel book and list all holidays except Saturdays and Sundays in column A.

Also, the header rows are omitted and the first row is the data row.

Create a sheet for the following calculations and convert it to a table.

ColumnValue
No1
Start DateAny value.
End DateAny value.
Formula=NETWORKDAYS(B2,C2,Holidays!A:A)

This Excel book should be in OneDrive or SharePoint, where it can be accessed by Power Automate.

After saving the Excel book, create a Power Automate flow.

Next to the trigger, place the "Update a Row" action and set it up as follows.

ColumnValue
Location
Document Library
File
Table
Excel book placement and table names.
Key ColumnNo
Key Value1
Start DateStart date of the period for which you want to calculate the number of business days.
End DateEnd date of the period for which you want to calculate the number of business days.

The number of business days is stored in the dynamic content "Formula" of the "Update a Row" action.

---

Links

Tips.(Power Automate Cloud flows)