web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Formula to set calenda...
Power Apps
Unanswered

Formula to set calendar default value to +14 working days from today

(0) ShareShare
ReportReport
Posted on by 134

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

Categories:
I have the same question (0)
  • Verified answer
    Rajkumar_M Profile Picture
    3,741 Super User 2025 Season 2 on at

    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.

     

     

     

     

  • nerdyplayer Profile Picture
    134 on at

    yay, thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard