Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter dates in data range
I'm trying to select a range of dates in an expense report. Colomn A has
dates from Jan 1 through Dec 31 2005. Colomn B lists a store name and colomn C and D have other data. I can filter any kind of numbers or text, but can't find a way to do the same for dates. Who can help me? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter dates in data range
If excel dates like 02/11/06 etc then they are just numbers and can be
filtered the same way, where lies your problem? -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Shelty" wrote in message ... I'm trying to select a range of dates in an expense report. Colomn A has dates from Jan 1 through Dec 31 2005. Colomn B lists a store name and colomn C and D have other data. I can filter any kind of numbers or text, but can't find a way to do the same for dates. Who can help me? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter dates in data range
I had the date in the format "10-JAN" and then it doesn't work. So I changed
the format to "1-10-05" and then it does work! Although the day is the same, it seems that the date has to show the year to work with autofilter. Thanks for your reply. "Peo Sjoblom" wrote: If excel dates like 02/11/06 etc then they are just numbers and can be filtered the same way, where lies your problem? -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Shelty" wrote in message ... I'm trying to select a range of dates in an expense report. Colomn A has dates from Jan 1 through Dec 31 2005. Colomn B lists a store name and colomn C and D have other data. I can filter any kind of numbers or text, but can't find a way to do the same for dates. Who can help me? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Data Range Mess | Charts and Charting in Excel | |||
Possible to chart data for dates implicit within a range? | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How can I check if data in an external data range is changed afte. | Excel Worksheet Functions |