Convert Week Starting day to Every Friday

[mehbpar]

Hello 

I am trying to get the Start of week to be Friday and then for the rest of the week display the same date until a new week starts. I tried using Mod and datetime add but did not succeed

DATETIMEADD([Date],Mod(ToNumber(DateTimeFormat([Date],"%w"))+2,7) . ,'days')

Excel attached, Workflow will e greatly apricated.

Thank you in Advance 

[TheOC]

hey @mehbpar 

Theres bound to be a few easier ways, however i tried this way to see if it works:

Basically in the bottom stream i am generating all dates from 2020 - 2025, and then mapping them based on what the previous fridays date was:

Then i am joining with your dataset. This seems correct, however its not exactly what your desired output is. I think there is some mistakes in your desired output if im not mistaken.
Please see attached.

Cheers,
TheOC

[Qiu · Accepted solution]

@mehbpar 
I tried the approach with Multirow Tool and hope you dont mind I roll back your data to the nearest Friday.