VBA for involving Dates

[adam.hafner]

Here is my question. I have an excel file that is a log file from our
system. It tracks dates of events and the type of events. It has
columns for each of the different fields. I have a second workbook
that references the log workbook and does a countif to count the
different occurances that an event type occurs between. What I would
like to figure out is if there is a way i can designate two cells, or
better yet, input boxes, that you could type in the beginning date and
end date, and then it would automatically find the correct cell range
to be input into my countif statement on other workbook. For example,
if i input 12/1/2005 as the start date and 12/12/2005 as the end date,
it would locate the last cell that had the date 12/12/2005 and the
first cell that had 12/1/2005 which would define the range that I could

use in my countif(WorkbookName!StartRef:EndRef, "search term"). For
reference, my dates are located in column A and my event type data is
located in column F. The dates are stored in MM/DD/YYYY HH:MM:SS
format. There is one row created for each event occurence. Any help
would be very much appreciated.


Thanks,


AdamH