View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Filter date for whole month.

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" wrote in message
...
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