Return the friday date for each week

[Gaetano_B]

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

[atcodedog05 · Accepted 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 😀👍

[jdunkerley79 · Accepted solution]

I suggest a formula tool with the expression:

DateTimeAdd([Start],5-ToNumber(DateTimeFormat([Start],"%w")),"days")

 Have attached a sample

[atcodedog05]

Happy to help 🙂 @Gaetano_B 

Cheers and Happy Analyzing 😀

[Raj008]

Hi jdunkerley79,

How to calculate Previous Friday date for Monday?

Thanks,

Raj

[nikhil07]

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?