using conditional criteria for weekdays
 

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.

using conditional criteria for weekdays
 

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

"thebehavioranalyst" wrote:

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.