Thread: auto filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default auto filter

Why not create an auxiliar column with =weekday(a1) and filter by this colum?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"SPISO" escreveu:

Column A has dates 05/01/09 on down. Is there a way I can auto filter those
rows that are between two days back through 6 days in the future? Let say
today is Tuesday. Two days back will be Sunday. I want Sunday's data to
fall off the filtered data tomorrow and have everything shift by one day.