ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   extract data from a date range (https://www.excelbanter.com/excel-discussion-misc-queries/260120-extract-data-date-range.html)

Detin8

extract data from a date range
 
Hi,
I am wondering if anyone can help me,

I have a range of dates with information attached to them, i am trying to
figure out how to show only a selected range of them.

e.g. i have a range from 10/07/2008 through to 20/3/2010 i only want to view
the data from 20/3/2009 through to the 20/3/2010.

can any one please show me how i can do this??

Gary Keramidas[_4_]

extract data from a date range
 
use the autofilter

--


Gary Keramidas
Excel 2003


"Detin8" wrote in message
...
Hi,
I am wondering if anyone can help me,

I have a range of dates with information attached to them, i am trying to
figure out how to show only a selected range of them.

e.g. i have a range from 10/07/2008 through to 20/3/2010 i only want to
view
the data from 20/3/2009 through to the 20/3/2010.

can any one please show me how i can do this??



ozgrid.com

extract data from a date range
 
AutoFilter; http://www.ozgrid.com/Excel/AutoFilters.htm

Or AdvancedFilter; http://www.ozgrid.com/Excel/advanced-filter.htm



--
Regards
Dave Hawley
www.ozgrid.com

"Detin8" wrote in message
...
Hi,
I am wondering if anyone can help me,

I have a range of dates with information attached to them, i am trying to
figure out how to show only a selected range of them.

e.g. i have a range from 10/07/2008 through to 20/3/2010 i only want to
view
the data from 20/3/2009 through to the 20/3/2010.

can any one please show me how i can do this??




All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com