Adding Days to skip to Monday

Question

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

DateTheDayInMonthDayIsWeekend08/07/20238Saturday114/01/202314Saturday109/09/20239Saturday106/08/20236Sunday1

Christina_H · Accepted Answer

This formula should shift any date to the following Monday:

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

binu_acs · Accepted Answer

@Deano478 One way of doing this