#1   Report Post  
Old December 29th 04, 07:53 PM
T
 
Posts: n/a
Default Filtering with dates

How do I filter using dates? I am trying to filter out dates for each month,
example I want to collect all of the entries with dates in September. I am
using Office 2003.

  #2   Report Post  
Old December 29th 04, 08:01 PM
Peo Sjoblom
 
Posts: n/a
Default

Assuming you want to use either datafilterautofilter or teh advanced filter

in autofilter use custom, where rows are greater than or equal to

09/01/04 (using US date format)

AND

is less than or equal to

09/30/04

click OK

using the advanced filter, you need 2 cells as criteria, leave the first one
blank,
assume we use D12, leave D1 blank and in D2 put

=MONTH(A3)=9

where A3 is the first cell with the dates,

then do datafilteradvanced filter, preferably copy to another location and
in the criteria range use

$D$1:$D$2

Regards,

Peo Sjoblom


"T" wrote:

How do I filter using dates? I am trying to filter out dates for each month,
example I want to collect all of the entries with dates in September. I am
using Office 2003.



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
grouping dates by week/month/etc. on cat. axis Kamal Hood Charts and Charting in Excel 4 January 23rd 05 11:06 AM
Ploting dates against a calendar and not as a simple events Barb Reinhardt Charts and Charting in Excel 2 January 22nd 05 03:41 AM
have dates entered from a list of data into an excel template Diane Excel Discussion (Misc queries) 1 December 28th 04 07:33 PM
Can I get email alerts when dates in excel are nearing? lucrecat Excel Discussion (Misc queries) 2 December 14th 04 06:14 AM
Using Filtering KellyB Excel Discussion (Misc queries) 2 December 6th 04 10:27 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017