Macro to input and compare date ranges

I need to allow the user to input a date range “From�-“To� through a form and
the date range should be placed in cells A1and A2 for in QQQ.xls. Then the
macro should compare the date range entered with the dates in column B in
another spreadsheet -ABS.xls and count only the records within that date
range. The result should be in a cell K1 in QQQ.xls for example.

Any help will be appreciated

Thanks
Vlad

I have a date selection userform example on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"vlad" <[email protected]> wrote in message
news:[email protected]...
>I need to allow the user to input a date range "From"-"To" through a form
>and
> the date range should be placed in cells A1and A2 for in QQQ.xls. Then the
> macro should compare the date range entered with the dates in column B in
> another spreadsheet -ABS.xls and count only the records within that date
> range. The result should be in a cell K1 in QQQ.xls for example.
>
> Any help will be appreciated
>
> Thanks
> Vlad
>