I’ve been working on a Flow recently that requires either the total amount of days between two dates, or the amount of working days (i.e. total days minus weekends and holidays), and the lack of a proper DateDiff expression in Power Automate has been a bit of a headache for me to work around.
If you’ve ever worked with Excel then you’ll know that the networkdays formula would be perfect…
Continue Reading ryanmaclean365’s Article on their blog
Calculate Working Days in a time period using Power Automate
Please note, since releasing this blog I optimised the solution to calculate working days to make it more accurate, you can read more in this blog post *** I’ve been working on a Flow recently that requires either the total amount of days between two dates, or the amount of working days (i.e.
Blog Syndicated with ryanmaclean365’s Permission