Determining a future date, again

  • Thread starter Thread starter Andrew Taylor
  • Start date Start date
A

Andrew Taylor

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
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
Click to expand...

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
 
Back
Top