auto filter

S

SPISO

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

Marcelo

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:
 
S

SPISO

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search closest day in the past from today 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
AVERAGE BASED ON 2 CRITERIA 1
Average days between dates 3
Calculation Time 2
Custom auto filter (Dates) 2
IF ARRAY with multiple conditions. 1
help with date formula 5

Top