User-797343556 posted
Hello people I got a question here. Is it possible for me to simplify this? Basically I want to get the date to be monday. It has to be the monday that is coming. 
Dim dow As Integer
dow = Today.DayOfWeek
If dow = 0 Then
dow = 1
ElseIf dow = 1 Then
dow = 7
ElseIf dow = 2 Then
dow = 6
ElseIf dow = 3 Then
dow = 5
ElseIf dow = 4 Then
dow = 4
ElseIf dow = 5 Then
dow = 3
ElseIf dow = 6 Then
dow = 2
End If