Week Number to Monday Date

[Creechyy]

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?

[TheRobRush · Accepted solution]

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)

[Creechyy]

This worked perfectly. Thank you so much!