Find records between two dates & check a box for each positive result

S

seals

Hi all,

I'm hoping someone may be able to start me off in the righ
direction:confused:

I have an excel sheet of approximately 900 rows, I wish to code in
function that gives the user a form to enter a start date. And the
search through the 900 rows and find all records between (User Input
and now (I believe it will be 7 days).

With each positive result I would like to check a checkbox on eac
record.


Any pointers in the right direction would be greatly appreciated.

Thankyou in advance,


Mark
:confused: :confused: :confused
 
R

Robin Hammond

Sounds like something better done in a sheet

Dates in A2:A900
Enter your search date in B1
Formula in B2:B900. Enter it in b2 and copy down.
=IF($A2>=$B$1,IF($A2<=NOW(),1,0),0)

You could then filter the results to just show the valid results, do a sum
to get the number of valids, sumproduct with another column to get a total,
etc.

Robin Hammond
www.enhanceddatasystems.com
 
Top