Need Formula to fill field with current Friday

[ACTUAL FINISH] = any day within the week, then [BILLED DATE] will = that week's Friday date For Example [ACTUAL FINISH] =11/1/22, [BILLED DATE] = 11/4/2022 [ACTUAL FINISH] =11/3/22, [BILLED DAT...