Hi guys, let's say I pick a date from Date picker in Power Apps. Based on the date selected, how can I automatically calculate the number of working days (excluding Sunday) in that particular month?
For example, I pick 11th October 2021, and I get 26 days for the month of October 2021.
I am able to do so using the EOMONTH and NETWORKDAYS.INTL functions in Excel but seems like there isn't a direct function to be used in Power Apps.
Solved! Go to Solution.
Those are not the numbers that I see with the formula.
Using the same formula I sent you with the dates that you have, this is what is produced using the function first for total days, then excluding Sun, then excluding Sun and Sat.:
Did you happen to make some change in the formula?