Hi All,
I have col. A (Regulatory Date) and I need to add a new column named 'Forecast Week Date' which returns the Friday for each date I have in column A.
i.e if column A= 6-Oct-20 then col. B= 9-Oct-20
if column A= 28-Sep-20 then col. B= 2-Oct-20 etc..
Any suggestions?
Many Thanks in advance,
Gaetano
Solved! Go to Solution.
Hi @Gaetano_B
Here is a workflow for the task.
Output: (use a select tool keep only required columns)
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi jdunkerley79,
How to calculate Previous Friday date for Monday?
Thanks,
Raj
Hi, I tried to tweak the formula a bit to get Monday's date. DateTimeAdd([Start],1-ToNumber(DateTimeFormat([Start],"%w")),"days").
But this is failing for every Sunday. Ideally I am looking for 2022-02-07 if my input is 2022-02-13. How can I achieve the same?