try this...

=Date()-Weekday(Date()) +3

this will give you tuesday of the current week
Wed +4
Thur +5
Fri +6
Next Mon +9...