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

[TABLE="class: grid, width: 218"]
<tbody>[TR]
[TD="align: center"]Date[/TD]
[TD="align: center"]Week Ending formula[/TD]
[/TR]
[TR]
[TD="align: center"]04/05/2018[/TD]
[TD="align: center"]10/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]05/05/2018[/TD]
[TD="align: center"]10/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]06/05/2018[/TD]
[TD="align: center"]10/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]07/05/2018[/TD]
[TD="align: center"]10/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]08/05/2018[/TD]
[TD="align: center"]10/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]09/05/2018[/TD]
[TD="align: center"]10/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]10/05/2018[/TD]
[TD="align: center"]10/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]11/05/2018[/TD]
[TD="align: center"]17/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]12/05/2018[/TD]
[TD="align: center"]17/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]13/05/2018[/TD]
[TD="align: center"]17/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]14/05/2018[/TD]
[TD="align: center"]17/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]15/05/2018[/TD]
[TD="align: center"]17/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]16/05/2018[/TD]
[TD="align: center"]17/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]17/05/2018[/TD]
[TD="align: center"]17/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]18/05/2018[/TD]
[TD="align: center"]24/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]19/05/2018[/TD]
[TD="align: center"]24/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]20/05/2018[/TD]
[TD="align: center"]24/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]21/05/2018[/TD]
[TD="align: center"]24/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]22/05/2018[/TD]
[TD="align: center"]24/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]23/05/2018[/TD]
[TD="align: center"]24/05/2018[/TD]
[/TR]
[TR]
[TD="align: center"]24/05/2018[/TD]
[TD="align: center"]24/05/2018[/TD]
[/TR]
</tbody>[/TABLE]

 

[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")