Find Business day from date field

Hi,

I've a date field which has list of all business day for a given month. But the problem is some are in proper format like 1,2,3etc..but some are are like Monday1,Tuesday2. This means 1st monday of month ,2nd tuesday of month.

Is there any way to extract business day from these kinds of format also?

I've attached my workflow to calculate business day.

Date	Bus. Day
202006	1
202006	2
202006	Monday2
202006	4
202006	Tuesday1
202006	Friday3

sampel.yxmd

Workflow

Accepted answers

ImadZidan

Hello @AnandKumar1 ,

I think the final join by record position was causing the issue I think. When putting records together, it was nothing there to map the order of such join. I generated a record ID from till the end to use in the join to ensure the records from the due and sent are mapped correctly.