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:

Using Apps Using Formulas

All responses (4)

Answers (2)

Verified answer

timl 31,946 on at

Like (0)

Report

Re: power app

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

timl 31,946 on at

Like (0)

Report
Re: power app

@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) ) )
SL-07111355-0 on at

Like (0)

Report

Re: power app

how can i exclude weekends for my due date
timl 31,946 on at

Like (0)

Report
Re: power app

Hi @swelihle

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

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