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. Column Value No 1 Start Date Any value. End Date Any 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 … Continue reading How to retrieve the number of business days within a specified period.(Power Automate Cloud flows)