next thursday formula?

[Ctrl]

hi all,
is it possible to get automatically the next thursday's date of a dat
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)

 

[Ron Rosenfeld]

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