Date Difference between two dates excluding weekends

(0) Share

Report

Posted on by codeworks

321

I want to calculate date difference between two dates excluding weekends.

On the ONChange Property of LeaveStartDate i have

Switch(Weekday(LeaveStartDatePicker.Value),
 7, Set(vStart, DateAdd(LeaveStartDatePicker.Value, 2)),
 1, Set(vStart, DateAdd(LeaveStartDatePicker.Value, 1)),
 Set(vStart, LeaveStartDatePicker.Value)
)

On the OnChange Property of the LeaveEndDate i have

Switch(Weekday(LeaveEndDatePicker.Value),
 7, Set(vEnd, DateAdd(LeaveEndDatePicker.Value, -1)),
 1, Set(vEnd, DateAdd(LeaveEndDatePicker.Value, -2)),
 Set(vEnd, LeaveEndDatePicker.Value)
)

The date difference is still counting weekends

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Ash13 576 on at

Like (0)

Report

Hi @codeworks

What is your DateDiff formula?

Was this reply helpful? Yes No
codeworks 321 on at

Like (0)

Report

vEnd - VStart

Was this reply helpful? Yes No
Ash13 576 on at

Like (0)

Report
Taking some 'inspiration' from this blog post: Excluding weekends and holidays in date differences in PowerApps | Microsoft Power Apps

Try:
RoundDown(DateDiff(vStart, vEnd, Days) / 7, 0) * 5 + Mod(5 + Weekday(vEnd) - Weekday(vStart), 5)

Was this reply helpful? Yes No
codeworks 321 on at

Like (0)

Report

This Works fine, but there is a bit of concern, if I pick Friday as the Leave Start day, and i pick Tuesday as the leave End day, its only counting Monday and Tuesday. it doesn't count Friday.

Was this reply helpful? Yes No