You’re offline. This is a read only version of the page.
106
Prof Bing stated that unlike excel, there's no networkday formula in powerapp.
I want to set a default date value to be 14 days from today. Want to exclude weekends.
Right now I have the formula as
Today() +14.
Guess if there's not a simple way, I could do +18 to offset the 2 weekends. ty
yay, thank you.
Hi @nerdyplayer
Try this formula
DateAdd(
Today(),
14 + If(
Weekday(Today()) + 14 * 7 > 5,
2,
0
) + If(
Weekday(Today()) + 14 * 7 = 5,
2,
If(
Weekday(Today()) + 14 * 7 = 6,
1,
0
)
),
TimeUnit.Days
)
Thanks!
If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
