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