Business Days only

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I'm using the following function to add X amount of business days (TxtSLACalc.Text) to a date. It counts business days correctly to a point (it skips weekends in the middle) however if the resulting end date is on a Saturday or Sunday it shows that instead of the following Monday or the preceding friday? What adjustment to this calculation do I need to make?

 DateAdd(
 DPAssignedDate.SelectedDate,
 Value(TxtSLACalc.Text) + 2 * If(
 (Weekday(
 DPAssignedDate.SelectedDate,
 StartOfWeek.Monday
 ) + Value(TxtSLACalc.Text)) > 5,
 RoundDown(
 (Value(TxtSLACalc.Text) - (5-Weekday(
 DPAssignedDate.SelectedDate,
 StartOfWeek.Monday
 ))) / 5,
 0
 ) 
 )
 )

Categories:

Building Power Apps

All responses (1)

Answers (0)

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@vffdd
Have you read this blog post by Microsoft? It will show exactly how to do it 🙂

Link To Post

https://powerapps.microsoft.com/de-de/blog/excluding-weekends-and-holidays-in-date-differences-in-powerapps/

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."