in the Monday columns,
=if(WEEKDAY(A1,2)=1,Yes,No)
in tuesday, same, but =2,Yes,No
etc.

"Ken" wrote:

Excel2003 ...

Col A contains dates ... Format = mm/dd/yy
Cols B thru H contain ... Text = Mon, Tue, Wed, Thu, Fri, Sat, Sun

I wish to format & setup so I can have a formula under each day of the week
that will peg the day vs the mm/dd/yy date in Col A.

If Col A = 01/17/07 ... No-No-Yes-No-No-No-No ... (Yes = Weds)
If Col A = 01/19/07 ... No-No-No-No-Yes-No-No ... (Yes = Fri)
If Col A = 03/05/07 ... Yes-No-No-No-No-No-No ... (Yes = Mon)

Thanks ... Kha