Maybe this

=A1+CHOOSE(WEEKDAY(A1),17,16,15,14,20,19,18)

Mike

"Andrew Taylor" wrote:

I have a date in A1, I would like the date in A2 to be the Wednesdaythat
falls after two weeks,
for example If i enter 10/11/2008 (11/10/08 for US) I would like it to
automatically display 26/11/2008 (11/26/08 US)

I've been playing around with formulas, but not having much joy.

Andrew