Count rows based on control selection

I have a user form that has 2 calender controls, the user selects the beginning and ending dates then clicks the execute button. The execute button is suppose to count the number of rows that match the date range the user selected and return it a label control. Here is my code, which by the way is all wrong and does not work, in it I have commented out ideas that I tried but would only match the dates exactly not the range of dates.

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

davesexcel,
I tried the code out and it only returns the number 14 no matter what date I select. I am racking my brain trying to make this work. Any other suggestions?

Here is the code as it stands. The issue I am having with it now is that, if I select a starting date other than the first date within the column, which happens to be 6/3/2010 and an ending date of 6/11/2010, then it returns the number 4. If I select 6/3/2010 and 6/11/2010 it return the correct number. I am stumped on this one, any ideas?

Please Login or Register  to view this content.

Let me explain what it is that I am trying to accomplish. My goal is to count the number of cells in column 'D' that fall between the selected dates. Therefore, if I chose a beginning date of 6/3/2010 and an ending date of 6/11/2010 and column 'D' looked like this:

column D
6/3/2010
6/4/2010
6/4/2010
6/7/2010
6/10/2010
6/11/2010
6/12/2010

Then the function would return the number 6.

In addition, if I chose a beginning and ending date of just 6/4/2010. Then, the function would return the number 4.

ANy ideas?? I am at a total lose.

I had a thought, could someone assit me in developing a fuction that calculates the number of days in a given range, then searches column 'D' for all those days that meet the criteria. The function will then return the number of cells that match the criteria. I am not sure if this is clear or not, right now it is just an idea.

Thanks to all

shg,
Thank you so very much for you suggestion. I had used it before but withput the CDate function, that was what I needed to make it work. Again, thank you.

Mekinnik