| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Linear Mode
