Auto filter months

  • Thread starter Thread starter Paul Smith
  • Start date Start date
P

Paul Smith

Dear All

Suppose that one has a list with a field containing dates. Can the
automatic filter be used to filter all records whose date is in March?
With the advanced filter it is easy to do that with the function MONTH.
However, I suspect that the automatic filter is not useful here.

Thanks in advance,

Paul
 
You could use a helper column with the function =MONTH(A2) copied down,
then apply the filter to this.

Hope this helps.

Pete
 
You could use a helper column with the function =MONTH(A2) copied down,
then apply the filter to this.
Click to expand...

Thanks, Pete. That is correct, but I was wondering whether one could
get a solution with the auto filter without adding extra stuff to the
list.

Paul
 
From the AuotFilter dropdown, choose Custom
In the first dropdown, choose 'is greater than or equal to'
In the text box, type 3/1/06
In the next dropdown, choose 'is less than or equal to'
In the text box, type 3/31/06
Click OK
 
From the AuotFilter dropdown, choose Custom
In the first dropdown, choose 'is greater than or equal to'
In the text box, type 3/1/06
In the next dropdown, choose 'is less than or equal to'
In the text box, type 3/31/06
Click OK
Click to expand...

Thanks, Debra, but your approach does not work if one has dates like:

3/1/06
3/31/06
3/1/05
3/31/05

and so on.

Paul
 
If they're real dates, it will filter for dates in that range, ignoring
dates from other years.
 
If they're real dates, it will filter for dates in that range, ignoring
dates from other years.
Click to expand...

That is my point: if the dates belong to the same year, your method
works fine; otherwise, as initially stated, I suspect that one cannot
use an automatic filter.

Paul
 
If the list contains real dates, even if they're from several years, the
custom filter will work correctly.

Have you tried it? Are you sure the column contains dates, not text values?
 
Sorry, I interpreted your original question as meaning filter for a
specific March. On reading it and your subsequent posts again, you
probably meant filter for any March date.

If you don't want to add a column to the list, you can use an Advanced
Filter. In the criteria range, leave the heading cell blank, and enter:

=Month(A2)=3

in the criteria cell below, where A2 is the date cell in the first row.
 
Back
Top