next thursday formula?

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

thanx in advance.

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ctrl" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

On Wed, 15 Feb 2006 10:12:40 -0600, Ctrl
<[email protected]> 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

Thank You So Much Bob And Ron