Unanswered

add business days

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I know there are a ton of posts on this ! but can't quite hit on the right one ... I use the following formula to add a set number of days to todays date. I was told previously this would calculate business days (I'm not too worried about holidays at the moment it's just weekends I want to exclude) but it still gives me weekends ! any suggestions for tweaks?

 Text( DateAdd(
 DateToday,
 Value(SLA.Text) + 2 * If(
 (Weekday(
 DateToday,
 StartOfWeek.Monday
 ) + Value(SLA.Text)) > 5,
 RoundDown(
 (Value(SLA.Text) - (5-Weekday(
 DateToday,
 StartOfWeek.Monday
 ))) / 5,
 0
 ) 
 )
 ),DateTimeFormat.LongDate)

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
Hi@vffdd

This is the formula I would use to add the value in your SLA textbox to the variable/field that you've defined as DateToday.

Can you see if that produces the correct result?

With({ startDate:DateToday, daysToAdd: Value(SLA.Text) }, DateAdd(startDate, daysToAdd) + RoundDown(daysToAdd/5, 0)*2 + Switch(Weekday(startDate, StartOfWeek.Monday), 5,If(Mod(daysToAdd, 5)>0,2,0), 4,If(Mod(daysToAdd, 5)>1,2,0), 3,If(Mod(daysToAdd, 5)>2,2,0), 2,If(Mod(daysToAdd, 5)>3,2,0), 1,If(Mod(daysToAdd, 5)>4,2,0) ) )

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on at

Like (0)

Report

@timl perfect that does it ! thank you

Was this reply helpful? Yes No