auto filter
 

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.

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.

auto filter
 

Thanks for the comment Marcelo. I have been trying to work something like
that out but I have to refilter the next day because it does not
automatically adjust when I reopen the workbook after midnight. I would like
it so i do not have to refilter each day.

"Marcelo" wrote:

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.