Getting Start of Week (Monday) from a Week Number

(1) Share

Report

Posted on by Hack-7

216 Super User 2025 Season 1

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

All responses (2)

Answers (1)

Hack-7 216 Super User 2025 Season 1 on at

Like (0)

Report

Re: Getting Start of Week (Monday) from a Week Number

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

SamFawzi-SmartSolut... 258 Super User 2025 Season 1 on at

Like (1)

Report
Re: Getting Start of Week (Monday) from a Week Number

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.