Power Platform Community Forum Thread Details

I need to be able to calculate and display the end of week date in my Power App.

I am using the following to get a hardcoded week ending date.

The output for the below is 2/15/2025. How do I make this formula dynamic, so that
the content in the label changes to the appropriate week ending date every Sunday.

Week start is Sunday, week ending is Saturday.

With({year:2025 , weekNo:7},
      With({weekDate: DateAdd(Date(year,1,1), 7* weekNo)},
           DateAdd(weekDate,
                   -(Weekday(weekDate)),
                  TimeUnit.Days
           )
      )
)