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