Power Query - Round to Specific Day of Week

[lager1001]

I have a column of dates that I want to apply a custom column to. The custom column will check the date column and determine if the day of the week is a Friday. If the date is a Friday it will add 7 days to it. If the date is not a Friday I will add 7 days and then round the date up to the following Friday. Any ideas?

 

[sandy666]

something like this?

Date	Friday
14/09/2020	25/09/2020
10/07/2020	17/07/2020
13/11/2020	20/11/2020
30/11/2019	13/12/2019
17/09/2020	25/09/2020
23/10/2019	01/11/2019
20/03/2019	29/03/2019
21/01/2019	01/02/2019
26/12/2019	03/01/2020
29/05/2019	07/06/2019
28/10/2020	06/11/2020
21/11/2019	29/11/2019
12/12/2020	25/12/2020
30/12/2020	08/01/2021
14/07/2020	24/07/2020
11/08/2019	23/08/2019
09/04/2019	19/04/2019
07/11/2019	15/11/2019
22/03/2020	03/04/2020
18/05/2019	31/05/2019
23/10/2019	01/11/2019
11/06/2020	19/06/2020
12/01/2019	25/01/2019
08/04/2020	17/04/2020
29/07/2020	07/08/2020