Hi,

Use a formula of
=D2+CHOOSE(WEEKDAY(TODAY()),1,0,6,5,4,3,2)

Or

=D2+7-WEEKDAY(TODAY()+5)

Daniel M.

P.S.: I haven't look at the file and don't know what the OP wants. This is
solely another brick in my unrelentless cursade (!) against the illogical
CHOOSE(WEEKDAY()) formula construction ;-))