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 Date Any value. Formula =NETWORKDAYS(DATE(YEAR(B2),MONTH(B2),1),EOMONTH(B2,0),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 … Continue reading How to retrieve the number of business days for a given month.(Power Automate Cloud flows)