Return the friday date for each week

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

Date Time

Accepted answers

atcodedog05

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 😀👍

friday.yxmd

jdunkerley79

I suggest a formula tool with the expression:

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

Have attached a sample

Friday.yxmd

All comments

atcodedog05

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 😀👍

friday.yxmd

jdunkerley79

I suggest a formula tool with the expression:

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

Have attached a sample

Friday.yxmd

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?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280