var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date Range Question
I was wondering how I can let a user select a date range from a table.
I want the user to be able to enter a starting date and an ending date to see only those sales between the entered dates.
End Date: 12/22/03
Can I do this with a formula?
If you want totals sales between those dates, yes you can do it with a formula.
Assume Dates in G5:G10, and Sales in H5:H10, then put in J4 the word "Start" (without "), and in K4 put "end"( w/o "). Then in J5 put 8/9/2003 and in K5 put 12/22/2003. Then put this formula in L5
I don't need the sales added in. I just want to be able to enter a date range and return the whole line for those dates. It looks like I can only do this with some kind of a filter. Is this true? I found it. I need to do auto filter and then custom filter.
Last edited by exdter; 01-30-04 at
Okay, assume the same setup as I outlined above. Then in L5 put this formula:
then copy this down as far as the list in column G (some should lacks)
In M5 put this formula:
Then copy down as far as the list in column G.
This will provide only those that are between the specified dates, but it will leave some lines blank. If you want to hide rows, then that will depend on VBA.
The filter will work. Try using Advanced Filter for up to three criteria at once.
I tried with the Advanced Filter and get an error. Maybe I'm doing it wrong. What should the criteria range window look like?
I click on the dates I want the criteria to be between and all the lines in my table disappear. I put is greater than or equal to 'low_date' and is less than or equal to 'high_date'
Thanks alot for your help and patience.
Sorry for the confusion. I am working on a project as was trying to go by memory and keep up with the project.
It is Advanced Filter that you want. For one time, criteria use the regular filter. For changing criteria use advanced filter.
I have to run. But will try to get back.