I have an SQL statement that returns the week number using the DatePart function. Is their a way I can get the friday date of the week number it returns to me ?

Thanks in advance for any help !!