Hello deb,

I'm not sure you've given a full enough explanation, assuming you always
want to display the next Monday or Thursday (whichever comes first), but on a
Monday or Thursday show that day, here's an alternative to Ron's suggestion

=A1+7-MAX(WEEKDAY(A1+{2,5}))

"Ron Rosenfeld" wrote:

On 29 Jan 2007 12:01:47 -0800, "Deb" wrote:

How do I display Monday or Thursday?


I have a column with the dates listed on the left a, on the right I'm
attemtping to display either Monday or Thursday.

3/16/2007 display 03/19/2007 (Monday)
2/10/2007 display 02/12/2007 (Monday)
4/3/2007 display 04/05/2007 (Thursday)

Thanks for your assistance


Perhaps:

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

will do what you require?


--ron