Answered

Add on working days to Today()

(0) Share

Report

Posted on by sammybridge

253

I am trying to, on the push of a button, set a date which is Today() + X number of working days. I cannot figure out how to get this working to account for every eventuality. I am going to be creating a number of tasks (list items) at one time using Patch and all of them will have a different Due Date (Today() + X days).

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

chrisog 213 on at

Like (0)

Report
Copy link

Link copied!

Hi @sammybridge,

It may be that the DateAdd() function could work for you. The syntax is DateAdd(date, number_of_units, unit)

So in your instance, if you can pre-determine somewhere in your app for the amount of days to add for each list item, you can simply use DateAdd(Today(), number_of_days, Days), where number_of_days refers to the value assigned to this list item.

Was this reply helpful? Yes No
Verified answer

timl 36,721 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @sammybridge

In the OnSelect property your button, you can add the following code:

Set(varDaysToAdd,3); Set(varResult, DateAdd(Today(), Value(varDaysToAdd) + RoundDown(Value(varDaysToAdd) / 5, 0)*2+ Switch(Weekday(Today()),5,If(Mod( Value(varDaysToAdd) , 5)>0,2,0), 4,If(Mod( Value(varDaysToAdd) , 5)>1,2,0), 3,If(Mod( Value(varDaysToAdd) , 5)>2,2,0), 2,If(Mod( Value(varDaysToAdd) , 5)>3,2,0), 1,If(Mod( Value(varDaysToAdd) , 5)>4,2,0)) ) )

The variable varDays defines the number of days to add (3 in this example).
The set statement stores the result of the calculation in the variable varResult.

This formula is based on @Siennas logic to exclude to exclude Saturdays & Sundays, so the credit goes to him.

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Adding-working-days-and-hours-to-a-date/m-p/98747

Was this reply helpful? Yes No