Hi all,

Not sure if I'm not finding the function I want elsewhere, or trying to
over-complicate the situation, but this is what I need:

I have an spreadsheet of course registrations, for different course dates
(in the same calendar year - ie 2008), and I want to be able to find all
courses for a single month. Each registration (including course date is a
single row).

This information would be found by entering into a single cell, the month
(OCT). The information in this cell would then be acted upon by an Advanced
Filter via a macro button to find all results, and paste a copy of the
results elsewhere on the spreadsheet for further action. (Adv filter and
macro button procedure works elsewhere, no issues on that section of
procedure.)

My problem is that I don't know how to best get the month information so
that it can be recognised by the single cell to determine which month (range
of data) it is searching for.

I can add an additional column, and have managed to successfully get a
nested IF statement to work for several months, but then of course run into
the 7-nested IF statements rule, which gives me a problem for the second half
of the year....

Where
A2 = Cell to specify course month to search for data (for adv filter)
A10 = Course Date, listed in date format.
B10 = Course Month (with format below, used as the reference field for the
parameter given in cell A2

eg
=IF(MONTH(A10)=1,"JAN",IF(MONTH(A10)=2,"FEB",IF(MO NTH(A10)=3,"MAR",IF(MONTH(A10)=4,"APR",IF(MONTH(A1 0)=5,"MAY",IF(MONTH(A10)=6,"JUN",""))))))

I tried to do a LOOKUP statement using the Month statement, but it didn't
like it, or I can't seem to get it right.

I can get a month number to display in a column if you enter just a month in
that date, but as far as I can see, this is just a display, not something I
can enact upon in an advanced filter (eg)

Enter 1 Sept or 23 Sept, it displays as Sept 08 (date format display), but
it is still the date entered particularly, and doesn't encompass all dates
that month.

All help gratefully received, thanks.


--
Wendy