cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Creechyy
Frequent Visitor

Week Number to Monday Date

Hi PowerApps Users!

 

I am trying to find Monday's Date based on a week number.

 

I am currently making an app in which my company can automatically assign a Monday due date to a toolbox talk (pdf).

 

I was able to connect my document library to the app and have assigned each with a particular week number. It is then filtered based on the current week number that is calculated from the Today() function.

 

Do you know how this would be possible?

 

1 ACCEPTED SOLUTION

Accepted Solutions
TheRobRush
Impactful Individual
Impactful Individual

I've done this formula from scratch, but it SHOULD work. Tested it by using multiple week numbers for the 2021 calendar and all tested returned correct date of that monday. It is limited to week numbers for current year, if you got into doing ones for future years it could still work but would need additional steps to calculate what they year selected was first.

 

In following code TextInput4.Text is where my week number is stored.

 

DateAdd(Date(Year(Today()),1,1),Value(Sum(Sum(Value(TextInput4.Text)-1)*7,7-(Value(Weekday(Date(Year(Today()),1,1)))-1)))+1,Days)
_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

View solution in original post

2 REPLIES 2
TheRobRush
Impactful Individual
Impactful Individual

I've done this formula from scratch, but it SHOULD work. Tested it by using multiple week numbers for the 2021 calendar and all tested returned correct date of that monday. It is limited to week numbers for current year, if you got into doing ones for future years it could still work but would need additional steps to calculate what they year selected was first.

 

In following code TextInput4.Text is where my week number is stored.

 

DateAdd(Date(Year(Today()),1,1),Value(Sum(Sum(Value(TextInput4.Text)-1)*7,7-(Value(Weekday(Date(Year(Today()),1,1)))-1)))+1,Days)
_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

View solution in original post

This worked perfectly. Thank you so much!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,342)