I wish to try and autofilter my data using =mod(a1,7)
A1 being a date.
I have tried changing the date to show
mmddyy ddd but it will not filter on the characters listed so even if it says 122203 Mon I can not filter using contains Mon in my filter.
Long and short of it is I want to use auto filter to filter out all mondays, tuesdays, wednesdays...
I could easily do it by adding data to my spread sheet and filtering on that but it just seems wrong to have to do so.