Funny, I thought it was you I pinched it from :-)
Bob
"Daniel.M" wrote in message
...
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 ;-))
|