| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter by month
got a bunch of coulmns with dates.. How do I filter each by using the
=today() so it will pull up the date and use that month to filter each time I run it.. Thanks, DJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
filter by month
"Duncan_J" wrote in message ... got a bunch of coulmns with dates.. How do I filter each by using the =today() so it will pull up the date and use that month to filter each time I run it.. Thanks, DJ =MONTH(TODAY()) will give you the current month /Fredrik |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
filter by month
If you wanted to use the year and month, then I'd use a helper column with
formulas like: =text(a1,"yyyymm") And filter by that. Duncan_J wrote: got a bunch of coulmns with dates.. How do I filter each by using the =today() so it will pull up the date and use that month to filter each time I run it.. Thanks, DJ -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter out unique additions month to month | Excel Discussion (Misc queries) | |||
| Filter date for whole month. | Excel Discussion (Misc queries) | |||
| Filter by month, then day, not just day | Excel Discussion (Misc queries) | |||
| Need to filter by month | Excel Discussion (Misc queries) | |||
| Filter by month | Excel Discussion (Misc queries) | |||
Hybrid Mode
