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

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

many thanks

"Mike H" wrote:

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

On Wed, 19 Nov 2008 06:51:01 -0800, Andrew Taylor <Andrew
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

I guess one question is what do you want to have happen if two weeks from today
IS a Wednesday. If, as you write, you want it to be the Wednesday AFTER, then:

=A1+22-WEEKDAY(A1+4)

If you want it to be the same Wednesday, then:

=A1+21-WEEKDAY(A1+3)
--ron