next thursday formula?

Ctrl · Feb 15, 2006

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

thanx in advance

Bob Phillips · Feb 15, 2006

=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 · Feb 15, 2006

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 · Feb 16, 2006

Thank You So Much Bob And Ron