Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Advance filters for dates

Hi,

I want to use advance filters to show for a particular month, i.e. February.
The data is in following format (as an example)...

1-Feb-07
5-Feb-07
10-Mar-07

I have used the following method and entered Feb-07 in one cell and Mar-07
in other cell. This has worked. I am wondering if there is another way to do
this using advance filters.

Thank you
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to advance dates by one year then up to 10 yrs in Excel chaplyn Excel Worksheet Functions 2 September 26th 07 05:44 PM
Dates ... advance 1 Month @ a Time Ken Excel Discussion (Misc queries) 3 February 28th 07 10:14 PM
How to copy with filters but not copy the filters in the middle? ztalove Excel Discussion (Misc queries) 0 November 1st 06 04:53 PM
Filters, Subtotal & Intacted Results after the filters' Removal kasiopi Excel Discussion (Misc queries) 5 February 24th 06 12:18 PM
How do I set up advance filters excel 2003 util Excel Discussion (Misc queries) 2 January 9th 06 03:41 PM


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"