Is it possible to get the first day of a week using week number?

[lwilly]

I have a number representing a week, (1 thru 52) is it possible to get the actual date that the week starts and ends on?<br><br>Thanks

 

[Guest_imported]

if you give it the first date of the year you want the week to start on then you can use <br>Dateadd(&quot;ww&quot;,[weeknumber]-1,weekstart)then do <br>Dateadd(&quot;ww&quot;,[weeknumber]-1,weekstart)+6 to get week end date<br>example this year the first week started 1/2/2000 so week 2 would start 1/9/2000<br>good luck