=A1+7-WEEKDAY(A1+2,2) -- this is the answer. It works. Thank you.