Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Calculate days exclude holiday and weekends

Is that possible I want to calculate the working days exclude holiday and weekend with the connection with calendar in outlook?
I know there is a way that using a list store the holiday and use power automate to achieve that, but I wonder is that any way can do this with outlook calendar?

Super User
Super User

I looked through the available web calls in the Outlook API and don't see a straight forward way to do it.  I was hoping to see one that let you get a list of days with properties (day of week, holiday, etc.) but it doesn't appear to be an option.  You may be able to trick it by looking for available times on every day, but it would be clunky and probably not foolproof.


Using the list approach is probably best. Here is an example.

How to calculate workdays with PowerApps | Papa Riedels Blog (




Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,414)