String from multiple fields to date format conversion

[dunkindonut7777]

Hi I have a data here that I want to combine the values and convert it to a date format. See sample below:

I want to convert it to a date format but if the period falls into weekends,i want to move it one/two days to make it on weekdays. See sample below:

Month	Period	Year	Output 1	Final expected output	Note
July	1st Period	2022	7/15/2022	7/14/2022	It was moved 1 day earlier since it falls on weekend
July	2nd Period	2022	7/31/2022	7/31/2022	Retain since weekday
August	1st Period	2023	8/15/2023	8/15/2023	Retain since weekday
August	2nd Period	2023	8/31/2023	8/31/2023	Retain since weekday

How can I transform it in alteryx (Final expected output) . Can you help me with this one please?

[flying008]

Hi, @dunkindonut7777 

Which days are your workday ?  1,2,3,4,5 or 7,1,2,3,4 ?

[binuacs]

@dunkindonut7777 One way of doing this

Note: I updated the date to 2023

[Raj · Accepted solution]

Hi since your dates are not appropriate for the required result but the output is obtained in required form.

you can use it and make your required output