On Mon, 10 Mar 2008 23:05:44 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

=A1+MOD(11-WEEKDAY(A1),7)
I have assumed that if the date is a Wednesday you will show that date, not
a week hence?
--
David Biddulph

WEEKDAY already does a MOD(n,7) function.

So if you make that assumption about NOT advancing a week if the date is a
Wednesday, simpler would be:

=A1+7-WEEKDAY(A1-4)

--ron