web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Getting Start of Week ...

Power Apps

Answered

Getting Start of Week (Monday) from a Week Number

(1) Share

Report

Report

Posted on by Hack-7

226 Moderator

I have a data source that only provides a week number for the content.

I need to generate the date for the Monday in that week.. I have found examples of how to get the date for something that is specific to date but nothing that references a number that equals the WeekNum.

DateAdd(Today(), 1 - Weekday(Today(), StartOfWeek.Monday), TimeUnit.Days);

Any guidance is appreciated.

Cheers

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Sam_Fawzi 894 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Here’s the step-by-step method to achieve this:
Determine the first day of the year: Start with January 1st of the given year.
Calculate the number of days to add: Subtract the weekday of January 1st from the week number multiplied by 7, then subtract the result of Weekday(January 1st) to align to Monday.
Here's a formula you can use in PowerApps:

// Define the year and week number Set(Year, 2024); Set(WeekNum, 10); // Get the first day of the year Set(FirstDayOfYear, Date(Year, 1, 1)); // Calculate the number of days to add to get to the Monday of the specified week Set(DaysToAdd, ((WeekNum - 1) * 7) + (2 - Weekday(FirstDayOfYear, StartOfWeek.Monday))); // Get the date of the Monday in the specified week Set(MondayDate, DateAdd(FirstDayOfYear, DaysToAdd, TimeUnit.Days));

This formula ensures that you correctly calculate the date of the Monday for the given week number, taking into account that the week starts on Monday.

Was this reply helpful? Yes No
Hack-7 226 Moderator on at

Like (0)

Report
Copy link

Link copied!

@samfawzi_acml thanks for this. I had missed the part of setting up the first day of the year.
Cheers

Was this reply helpful? Yes No

Join the conversation