Getting a date from the day of the week

[CaseyW]

Can't seem to find this anywhere and hoping it's possible. I have a report that provides a weekly order day, I am trying to convert this day into a date and can't seem to figure it out. All dates would be the next occurrence of the listed day.

Lane	Location 1	Go Live Cadence	PO Drop Day	Pick Day	Ship Day
Anchorage	D059	Weekly	MON	TUE	WED
Fife	D053	Weekly	MON	TUE	WED
Buford	D021	Weekly	FRI	MON	TUE
Buford	D0VA	Weekly	FRI	MON	TUE
Dixon	D069	Weekly	MON	TUE	WED
Hammond	D0VZ	Weekly	MON	TUE	WED
Hammond	D043	Weekly	MON	TUE	WED
Montgomery	D0V2	Weekly	MON	TUE	WED
Montgomery	D0OC	Weekly	MON	TUE	WED
Honolulu	D055	Weekly	MON	TUE	WED
Ontario	D073	Weekly	MON	TUE	WED
Ontario	D0EW	Weekly	MON	TUE	WED
Jefferson	R2JG	Weekly	MON	TUE	WED
Weston	D022	Weekly	MON	TUE	WED
Weston	D0EM	Weekly	MON	TUE	WED
Waukegan	D0CG	Weekly	MON	TUE	WED
Allentown	D07A	Weekly	TUE	WED	THU
Baltimore	D0HD	Weekly	TUE	WED	THU
Baltimore	D0V1	Weekly	TUE	WED	THU

[atcodedog05]

Hi @CaseyW 

Here is a workflow for the task. It gives date of next week date.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[CaseyW]

Dates don't match correctly in the solution, should match to the dates below but they don't.

Fri-     10/24

Mon - 10/26

Tue -  10/27

Wed - 10/28

Thu -  10/29

[atcodedog05 · Accepted solution]

Hi @CaseyW 

Apologies my bad. Fixed it

Output:

Hope this helps please check and let me know.

[CaseyW]

Perfect thank you!

[atcodedog05]

Happy to help 🙂 @CaseyW 

Cheers and Happy Analyzing 😀