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
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.
Blog Syndicated with ryanmaclean365’s Permission
More About This Author
Array
Dyn365CE31 March 2021Finding Records Shared With a Specific Team or User
Dyn365CE14 October 2020Calculate Full Months between two dates with Power Automate
Dyn365CE3 August 2020Converting UTC Date Time to UNIX Time with Power Automate
Dyn365CE28 July 2020Converting Excel Date Time Serial Values With Power Automate