View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Gary is offline
external usenet poster
 
Posts: 273
Default how to check for days of the week

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: ?