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.
|