Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter date for whole month.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter date for whole month.
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" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter date for whole month.
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) "Rao Ratan Singh" wrote in message ... 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Month in Date With Month in Header | Excel Worksheet Functions | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON | Excel Worksheet Functions | |||
Month to date sales - reset in new month??? | Excel Worksheet Functions |