Determining a future date, again

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select row by ID to nearest date, future (or past if no future dat	Trexner	Microsoft Access Queries	4	9th Nov 2009 09:44 PM
Determining the day of the week far into the future.	Frank Martin	Microsoft Access Forms	2	22nd Oct 2008 12:27 AM
Formula for determining if two date columns fall within specific date range	Igottabeme	Microsoft Excel Worksheet Functions	2	21st Apr 2006 02:50 AM
Formula for determining if two date columns fall within specific date range	Igottabeme	Microsoft Excel Misc	1	20th Apr 2006 10:03 PM
Determining a future date...	=?Utf-8?B?TldP?=	Microsoft Excel Misc	10	29th Dec 2005 12:15 AM