Week ending formula

[thedeadzeds]

Hi Guys, i'm wondering if the below is possible. My weeks run from Thursday to Friday so is there a way to use a formulas to pull out the Friday date within that week. The result would need to look like the 'Week ending formula' column below

Thanks

Date	Week Ending formula
04/05/2018	10/05/2018
05/05/2018	10/05/2018
06/05/2018	10/05/2018
07/05/2018	10/05/2018
08/05/2018	10/05/2018
09/05/2018	10/05/2018
10/05/2018	10/05/2018
11/05/2018	17/05/2018
12/05/2018	17/05/2018
13/05/2018	17/05/2018
14/05/2018	17/05/2018
15/05/2018	17/05/2018
16/05/2018	17/05/2018
17/05/2018	17/05/2018
18/05/2018	24/05/2018
19/05/2018	24/05/2018
20/05/2018	24/05/2018
21/05/2018	24/05/2018
22/05/2018	24/05/2018
23/05/2018	24/05/2018
24/05/2018	24/05/2018

<tbody>
</tbody>

 

[Rick Rothstein]

Does this do what you want...

=A2-WEEKDAY(A2,15)+7

 

[Rick Rothstein]

Does this do what you want...

=A2-WEEKDAY(A2,15)+7

Actually, this should also work...

=A1-WEEKDAY(A1-5)+7

 

[Tetra201]

Or this one, with a single reference call:

=WORKDAY.INTL(A2-1,1,"1110111")