Hi

If i understoond well, your point, then try this:

=A1+6-WEEKDAY(A1;2)


Hope to helps you