Getting Start of Week (Monday) from a Week Number

(1) Share

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 (2)

Answers (1)

Verified answer

Sam_Fawzi 750 Super User 2025 Season 2 on at

Like (1)

Report
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

@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