Date Formula

  • Thread starter Thread starter wmjenner
  • Start date Start date
W

wmjenner

Is there a simple way to lookup a value using the day of the week a
the criterion? From a list of dates, I want to see if there is
statistical correlation if a certain event happens every, say, Tuesda
rather than another day of the week. Something like this:

A

Mon. 5/17
Tues. 5/18
Wed. 5/19
(etc.)

I want to lookup all values in this range that fall on Tuesday.
tried AutoFilter/Custom/Contains but that didn't work. Can this b
done?

Thanks
 
Thanks Dave. Actually they are true dates. I just formatted them for
letters of the month (and maybe my example with the periods isn't vali
but they are, in fact, values and not text). I'll try your wildcar
and let you know. Thanks
 
Use a help column in the filter, in the help column use a formula like

=TEXT(A2,"dddd")

copy down, now filter on the help column and select the weekday
from the help column dropdown
 
The helper column works great. Thanks Peo!

I also tried the wildcard (Tue*) but it returns no values (everythin
is filtered out)
 
Back
Top