Posted to microsoft.public.excel.worksheet.functions
|
|
how to check for days of the week
Your entire formula can be replaced by this much shorter one...
=TEXT(D5,"dddd")
--
Rick (MVP - Excel)
"Rajesh Mehmi" wrote in message
...
Hi
You can add a column next to date column and put the formula below, copy
it down , This will give you the weekday ( SUNDAY =1)
you can use sum if to get totals for the desired days
=IF(WEEKDAY(D5,1)=1,"Sunday",IF(WEEKDAY(D5,1)=2,"M onday",IF(WEEKDAY(D5,1)=3,"Tuesday",IF(WEEKDAY(D5, 1)=4,"Wednesday",IF(WEEKDAY(D5,1)=5,"Thursday",IF( WEEKDAY(D5,1)=6,"Friday",IF(WEEKDAY(D5,1)=7,"Satur day","")))))))
Best regards
Rajesh Mehmi
"Gary" wrote in message
...
I have several sheets that I need to collect data from. Coloumb A has
dates
Sunday thru Saturday, formated as: Tuesday, August 25, 2009 There
are twelve sheets like this....one for each month. On the "Report"
sheet, I
need to collect certain 'days of the week' which are Tuesday and
Thursdays
only (this may change later) and use the values associated with those
days.
The cells that each day is in will change from month to month and year to
year. Is it possible to tell Excell to 'locate' a certain day in a
particular coloumb and bring the associated values in coloumbs B thru H?
I don't always find my way to this area, would you mind if you contact me
at: ?
|