Hi,
I'm building leave request for my team, on the submit page I want to show number of leave days selected using DateDiff but the problem is I need to exclude weekend.
As this scenario 11 is Friday and 14 is Monday so Total date shall be 2 (weekend excluded)
Any solution for this, Thank you for your help 🙂
Solved! Go to Solution.
Hi @MIGHSKI
This formula should work for you, and calculate the difference *inclusive* of the start and end date. You would obviously replace the startDate and endDate values with references to your date picker controls. :
With({ startDate:DateValue("2022-02-11"),
endDate:DateValue("2022-02-14")
},
RoundDown(DateDiff(startDate, endDate, Days) / 7, 0) * 5 +
Mod(5 + Weekday(endDate) - Weekday(startDate), 5)
+ 1
)
The caveat with this formula is that the start and end dates must not be weekend dates.
Hey!!
This might help you
https://powerapps.microsoft.com/es-es/blog/excluding-weekends-and-holidays-in-date-differences-in-po...
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!
Best regards,
Gonçalo Nogueira
Check my LinkedIn!
Check my User Group (pt-PT)!
Last Post on Community
My website!
Hi @MIGHSKI
This formula should work for you, and calculate the difference *inclusive* of the start and end date. You would obviously replace the startDate and endDate values with references to your date picker controls. :
With({ startDate:DateValue("2022-02-11"),
endDate:DateValue("2022-02-14")
},
RoundDown(DateDiff(startDate, endDate, Days) / 7, 0) * 5 +
Mod(5 + Weekday(endDate) - Weekday(startDate), 5)
+ 1
)
The caveat with this formula is that the start and end dates must not be weekend dates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
191 | |
45 | |
43 | |
38 | |
35 |
User | Count |
---|---|
261 | |
83 | |
81 | |
70 | |
69 |