Filter date for whole month.

[Rao Ratan Singh]

Hi all,
I have a Sales Transaction worksheet which have column of dates of
particular sale.
I want to filter date e.g. 01.04.2008 to 30.04.2008

Column A
01.04.2008
01.04.2008
01.04.2008
02.04.2008
02.04.2008
03.04.2008
03.04.2008
04.04.2008
05.04.2008
05.04.2008
07.04.2008
07.04.2008
08.04.2008
08.04.2008
25.04.2008
25.04.2008
29.04.2008

 

[Bob Phillips]

If they are real dates you can just use greater than and less than
conditions in a custom filter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rao Ratan Singh]

Hi Bob,
Yes these are real dates. but in excel 2007 greater than and less than
conditions does not display particularly this column of date in drop down
list.

please tell me in detail.

Thanks and regards

yours

RRS

 

[Bob Phillips]

In 2007, there is a Date Filter option, and at the bottom of this list there
is Custom Filters... option, where you can do the greater than and less
than conditions as in previous versions.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)