Search records with dates, then Group by month

M

mjkunkel

I'm writing a macro that searches a spreadsheet for dates. I want to
find records that are associated with a certain month. The dates in
the spreadsheet are in the mmddyyyy format. How can I write code that
would recognize any date within a given month and return true. For
example, 7/12/2007 or 7/2/2007 would both return "true" for the month
of July. 5/5/2007 or 5/27/2007 would return "true" for May, etc.

thanks
 
C

CLR

You could use the Autofilter to give you a LessthanGreaterthan range.
Otherwise, keying just on Months, you would get May06, May07, etc if your
database spanned more than one year. Use of the Autofilter will also allow
extracting lesser periods, like two weeks, or greater periods, like 3 months,
etc.

hth
Vaya con Dios,
Chuck, CABGx3
 
Top