| View previous topic :: View next topic |
| Author |
Message |
dsmithe Newbie

Joined: 01 Apr 2009 Posts: 2
|
Posted: Sat Feb 04, 2012 6:50 pm Post subject: Autofilter by Month |
|
|
Is there a way to Autofilter by month?
Thanks |
|
| Back to top |
|
 |
ozzie OOo Advocate

Joined: 29 Jul 2010 Posts: 330 Location: victoria
|
|
| Back to top |
|
 |
ozzie OOo Advocate

Joined: 29 Jul 2010 Posts: 330 Location: victoria
|
|
| Back to top |
|
 |
dsmithe Newbie

Joined: 01 Apr 2009 Posts: 2
|
Posted: Sat Apr 07, 2012 12:12 pm Post subject: Solved |
|
|
Thanks
This solution will work great for my pivot tables.
I'll try for a workaround with the AutoFilter.
The date format is mm/dd/yy and i would like to use AutoFilter to filter by month. |
|
| Back to top |
|
 |
karolus OOo Advocate

Joined: 22 Jun 2011 Posts: 208
|
Posted: Sat Apr 07, 2012 11:57 pm Post subject: |
|
|
Hi
| Quote: | | ...and i would like to use AutoFilter to filter by month |
Extract the month-number: =MONTH( your_date )
or the month-name =TEXT( your_date ; "mmmm")
into a helper column , and 'Autofilter' by Helpercolumn.
Karo |
|
| Back to top |
|
 |
|