Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I create a formula to locate data between two dates?
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. |
#2
|
|||
|
|||
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 "A shink" <A wrote in message ... 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. |
#3
|
|||
|
|||
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" wrote: 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 "A shink" <A wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula presumes cells have data | Excel Worksheet Functions | |||
how do I locate a cell that provides data to a formula ? | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |