web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Adding Business Days t...

Power Apps

Answered

Adding Business Days to Date Picker

(0) Share

Report

Report

Posted on by MicroMarc365

101

Submit Date: Date Picker

Due Date: Date Picker

When a user selects a submit date, I would like to set the Due date to -18 business days.

This is the current formula I have on the DefaultDate of the Due Date date picker:

Text(DateAdd(SubmitDate.SelectedDate, - 18), "mm-dd-yyyy")

Any advice would help.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@MicroMarc365 - one method:

With( {_days: -18}, DateAdd( SubmitDate.SelectedDate, Value(_days) + RoundDown( (Weekday( SubmitDate.SelectedDate, StartOfWeek.Monday ) + Value(_days) - 1) / 5, 0 ) * 2, TimeUnit.Days ) )
MicroMarc365 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked perfectly! Thanks!

Join the conversation