Searching between 2 dates.Its hard work..

globalg · Mar 14th, 2002, 10:36 AM

Hi.I have a worksheet of growing data exported from Access.In Column A I have the dates ie:A1 = 01/01/02, A99 =10/02/02 etc etc.What I would like to do is be able to select all the data between 2 dates.If I could get a message box appear with "StartDate" "EndDate" and then filter all data into worksheet that falls between these 2 dates.I have created a pivot table which I believe is ideal but the users are reluctant to use it.Also Pivots can not group into weeks which I may require.If anyone has came across something similiar I would be grateful.
Thanx for your time

Mark W. · Mar 14th, 2002, 10:40 AM

If you choose your begin/end dates carefully you can Group dates by week. And then, there's always the WEEKNUM worksheet function.

[ This Message was edited by: Mark W. on 2002-03-14 09:41 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 10:36 AM	#1
globalg New Member Join Date: Mar 2002 Posts: 1	Hi.I have a worksheet of growing data exported from Access.In Column A I have the dates ie:A1 = 01/01/02, A99 =10/02/02 etc etc.What I would like to do is be able to select all the data between 2 dates.If I could get a message box appear with "StartDate" "EndDate" and then filter all data into worksheet that falls between these 2 dates.I have created a pivot table which I believe is ideal but the users are reluctant to use it.Also Pivots can not group into weeks which I may require.If anyone has came across something similiar I would be grateful. Thanx for your time

Mar 14th, 2002, 10:40 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	If you choose your begin/end dates carefully you can Group dates by week. And then, there's always the WEEKNUM worksheet function. [ This Message was edited by: Mark W. on 2002-03-14 09:41 ]