Getting the Monday date from a week number 1

[TomSalvato]

Good morning, Experts.

Hopefully there's an easy way to do this. I'm trying to create an expression in builder.
I have a 'Week Number' field (which is just what it sounds like, the week number of the year for that record).
I'd like to get the Monday date for that week number.

For example:
if the week number is 18 (which is this week), then I'd like to return 04/29/2024.
if the week number is 17, then I'd like to return 04/22/2024.

* if it makes it any easier, I also have the specific date for each record in a date field.

Thanks in advance!

 

[strongm]

=DateAdd("ww",[WeekNumber]-1,DateSerial(2017,1,2))

 

[TomSalvato]

Perfect. Thanks so much, strongm!

Slight modification to the DateSerial function for my needs.
Here's the final formula for anyone else that may someday be looking at this ...

MondayDate: DateAdd("ww",[My_Table]![Week Number]-1,DateSerial(Year([date]),1,1))

* Putting the Year function within the DateSerial function should alleviate the need to hardcode the year every January. -TS