Adding Days to skip to Monday

[Deano478]

Hey Folks,

This is probably a common question but I couldn't find a way of doing by looking at past solutions, so essentially I have this data:

And I just want to be able to add days to skip to the Monday of the next week. 

As always any help and guidance is much appreciated,

Cheers

Date	TheDayInMonth	Day	IsWeekend
08/07/2023	8	Saturday	1
14/01/2023	14	Saturday	1
09/09/2023	9	Saturday	1
06/08/2023	6	Sunday	1

[Christina_H · Accepted solution]

This formula should shift any date to the following Monday:

DateTimeAdd([Date],8-ToNumber(DateTimeFormat([Date],"%u")),"day")

[binuacs · Accepted solution]

@Deano478 One way of doing this

[Deano478]

@Christina_H  and @binuacs Cheers for the help guys I was able to use your solutions and adapt them into my WF