How can I create a formula to locate data between two dates?

[Guest]

I am trying to find data between a beginning date and an end date that the
user can change. An example is looking for returns between January of 1980
through December of 1984 (These dates should be able to be manipulated )for
products 1,2,3 and 4 during that time period.

 

[JulieD]

Hi

we'll need to know how you're thinking of implementing this and what the
structure of your workbook is ... a "simple" solution would be to set up
either data / filter / autofilter and train the users to use the CUSTOM box
or to set up an advanced filter - but this assumes all your data is on one
worksheet in list /database format.

Cheers
JulieD

 

[Guest]

JulieD:

Thanks for the reply. I am putting together a statistical analysis of these
products. The monthly and quarterly data is inputed on a seperate tab. The
"user" can set their dates that they want on a seperate tab to analyze the
performance between those dates.


I am not real keen on training people on how to use auto filter or custom box.


An example would be this:

We want to analyze the performance of products 1,2,3 and 4. We have monthly
and quarterly data going back to 1980 through present. We only want to look
at from January 1995 through december of 2000.

next we may want to look at the dates from March of 1987 through June 0f
2003. Etc...


Date P1 P2 .....

Jan'80 690 730 .....
..
..
..
Dec'04 1500 4300 .....

next tab (Analysis of sub dates)

Date P1 P2 .....

Jan'95
..
..
..
Dec'04

Std Deviation X1 X2

T-Statisitic y1 Y2
etc....


Does that help?

 

[JulieD]

Hi

sorry for the delay in getting back to you, i'm not sure the best way of
achieving this .. .you might like to have a look at using pivot tables from
multiple consolidation ranges (www.contextures.com/tiptech.html has notes on
this) but personally, i would use a database to store information like this.

Cheers
julieD