Date starting change

[Maanvendra]

I have a column of dates

Date
30-04-2024
08-05-2024
09-05-2024
14-05-2024
17-05-2024
22-05-2024
24-05-2024

I want to get aditional column for which the starting day will be mon and with the duration of 2 weeks strating from 29-04-24 and with a gap of 2 weeks. so
the output will be as below.. this is a urgent requirement.

Date_Out
29-04-2024
29-04-2024
29-04-2024
13-05-2024
13-05-2024
13-05-2024
13-05-2024

[Deano478 · Accepted solution]

Hey @Maanvendra have a look at this Workflow attached

[Maanvendra]

Hi, this works .

Thanks a lot