Power Apps Date Calculations for Business Days

In this video on Power Apps Date Calculations for Business Days, we will learn about the Power Apps date and time functions & cover 2 scenarios for business days calculations in Power Apps.

Scenario 1: Calculate date difference in business days between 2 dates.

Scenario 2: Add Business days to a given date. Ideal for calculating due date for tasks.

Formula used to get list of dates OnStart function of the Power App

[hisespeaking]

Brilliant! Thanks for sharing and explaining it in detail as well.

[clarkelbing]

I can't tell you how grateful I am to your videos! You've literally saved my sanity! Would love to collaborate with you at some point. Thank you for explaining things so straightforward!

[mandijohnson-fisher]

Once again, THANK YOU!! I wasn't sure where to even begin with this formula. I took it a step further and used this to calculate available hours for associates each month for a capacity report. You always help me with my Power Apps obstacles!

[saurabhtalele]

Great video, Note for Viewers: please make sure while testing the app (Means not published), Please start App from " Run OnStart ", so that your holiday collection will be made easily And You can test it finely and smoothly. TmeStamp 5:50

[Recker]

I was breaking my head for more than a week over the second use case that you talked about in your video. Wow. This just is amazing. Thank you Reza!

[devagunalan]

Hi Reza,
Firstly good tutorial. Just a quick one. The days calculated in your example from the 6/26 to the 6/30 should be calculated as 3 days as start to end. I had the same issue. The workaround that I did was to add a day to the end date. As such
RoundDown(
DateDiff(
DatePicker1.SelectedDate,
DateAdd(
DatePicker2.SelectedDate,
1
),
Days
) / 7,
0
) * 5 + Mod(
5 + Weekday(
DateAdd(
DatePicker2.SelectedDate,
1
)
) - Weekday(DatePicker1.SelectedDate),
5
),
This resolved it. Just a suggestion to anybody who has been in the same shoe. Cheers.

[turisabela]

Your video is easy to follow along! Congrats and thanks once again!

[simonball]

You’re a true master at teaching this Reza. Great content, many thanks.

I have been looking for these formulas, glad I found it, still available … thanks Reza.. as usual great vid ✅✅

[RicksterLuna]

Such helpful videos! I was looking for this exact solution and you made that possible! Thank you as always!

[Franzero]

Remarkable and outstanding as always my friend!

[mangeshmalvankar]

Thank you Reza! It helps me to sort out date difference very fast.

[FarhanKhan-lrtv]

Thanks Reza, I think you maked PowerApp so much easy for learn ❤️

[christianigbaras]

Thank you so much you're really a life saver!

[rgamiao]

New to PowerApps. Thank you for this wonderful tutorial. I've applied your logic to two date pickers where if a particular date is selected on datepicker 1, then it would dynamically populate datepicker 2 (in view mode). Question please. How would you adjust this logic where onchange of datepicker 1, it would dynamically populate datepicker 2, 3 and 4 on the same form with different dates? I tried passing differing number of records in Last(FirstN( colDateRange[, varNumberOfRecords ] )).Date, in each datepicker, but each time Last pulls the last record of colDateRange. Would I need to create a different collection? For example, datepicker 2 shows values: Last(FirstN( 121records, 121 )).Date which pulls the 121st record, datepicker 3 I have Last(FirstN( 121records, 108 )).Date, but it pulls the 121st date instead of the 108th date. Appreciate any direction.

[MarcCotterill]

Great video. I know it's a few years old, but is there a way of doing the holidays lookup when the formula is being created within a table column within a model-driven app? I have UK bank holidays listed in a separate table within my solution, but I can't get the formula to find it when I try to reference it as part of the calculation. Thanks in advance!

[RenanNMatias]

Thank so much!!!! I'm very grateful for your help, it helped me a lot.

[MrBekimpilo]

Hi Reza, thanks for the great explanation. This makes it easy for a beginner. I wanted to find out how to include half day calculations, assuming I applied for half day leave instead of a full day…?

[hpkeong]

Hi thanks for such a short and precise explanation where it is much simpler than many others.
Just wonder, RemoveIf(DS, to exclede weekday), it is pretty straightforward. Just curious, how RemoveIf can detect CountRows(Filter..holiday) > 0? Wish to know how does it really work out though it looks simple.
TQ

[RupaliTayde-fins]

@rezadorrani, How we can calculate no. of holidays approved till today?