Answered

power app

(0) Share

Report

Posted on by SL-07111355-0

hey guys can you'll kindly assist me, I'm trying to create the formular that will be set on date control default as a due date, due date is two weeks from current date.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

timl 36,558 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @swelihle

This will give you the date that is 2 weeks from today:

DateAdd(Now(), 14, TimeUnit.Days)

Was this reply helpful? Yes No
SL-07111355-0 on at

Like (0)

Report
Copy link

Link copied!

how can i exclude weekends for my due date

Was this reply helpful? Yes No
Verified answer

timl 36,558 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
@swelihle

If you want to return a date that's 10 working days from today (ie, 2 weeks excluding weekends), this is the formula that you would use.

With({ startDate:Now(), daysToAdd: 10 }, 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
Verified answer

timl 36,558 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @swelihle - can you confirm whether the above answers your question?

Was this reply helpful? Yes No