using conditional criteria for weekdays

[Guest]

I can't seem to figure out how to use IF to select data for a specific day of
the week. I've tried variations like =if(A2:A24=weekday(A2),x,y). What I'd
like to do is compare weekday performance data: compare Monday data with
Tuesday data etc. across the month and year.
Do I have to change the date format I'm using? The input fomat I used is
00/00/00 and the cell display is Monday, April 2, 2007.

 

[Guest]

Have you considered using Pivot tables and groupiong by Day etc? That moght
work better.
Sheila