Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating for weekdays | Excel Worksheet Functions | |||
need help with conditional formatting 3 criteria | Excel Worksheet Functions | |||
Conditional Formatting with more than 3 Criteria | Excel Discussion (Misc queries) | |||
Can I set more than three criteria for conditional formatting? | Excel Worksheet Functions | |||
conditional criteria in DSUM | Excel Discussion (Misc queries) |