mm/dd/yy vs Mon, Tue, Wed etc
maybe i am confused by this ...
If Col A = 01/17/07 ...
Cols B thru H contain ... Text = Mon, Tue, Wed, Thu, Fri, Sat, Sun [e.g. B1:H1]
on next column B same row. (ie. B2)
=IF(TEXT(WEEKDAY($A2),"DDD")=B$1,"Yes","No")
copy paste on rows and columns.
*****
birds of the same feather flock together..
"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
|