next thursday formula?

[Ctrl]

hi all,
is it possible to get automatically the next thursday's date of a date using excel formulas

thanx in advance.

[Bob Phillips]

=A1+CHOOSE(WEEKDAY(A1),4,3,2,1,0,6,5)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ctrl" <Ctrl.23a3iy_1140020100.3457@excelforum-nospam.com> wrote in message
news:Ctrl.23a3iy_1140020100.3457@excelforum-nospam.com...
>
> hi all,
> is it possible to get automatically the next thursday's date of a date
> using excel formulas
>
> thanx in advance.
>
>
> --
> Ctrl
> ------------------------------------------------------------------------
> Ctrl's Profile:
http://www.excelforum.com/member.php...o&userid=31584
> View this thread: http://www.excelforum.com/showthread...hreadid=512749
>

[Ron Rosenfeld]

On Wed, 15 Feb 2006 10:12:40 -0600, Ctrl
<Ctrl.23a3iy_1140020100.3457@excelforum-nospam.com> wrote:

>
>hi all,
>is it possible to get automatically the next thursday's date of a date
>using excel formulas
>
>thanx in advance.


=A1+8-WEEKDAY(A1+3)


--ron

[Ctrl]

Thank You So Much Bob And Ron