Establishing a date range help with macro
 

Hi, I have a column that has dates of transactions, and I'm writing a
macro that asks a user for a range and then performs a task on all rows
where the dates are within the range. The problem I'm having is that I
don'tk now how to write a robust search where even if the date is not
specifically in the range, it will start at the next date.

In other words, I don't want to step through the entire database, and I
want to perform my action on just a specific date range, and I can't
just search for the date because that specific day may not have a
transaction record.

Any idea on how to approach this??