Thanks Andy

that would work if i was using thing full year as a schedule
following is the first 3 months, you will notice that 1st thursday of every
month is Youth Leaders Meeting; 2nd Friday of every month is Youth Specific
Meeting; 3rd Friday is Youth Social and Last Sunday of every month is Youth
Service. This runs from Feb to November.

I also have this repeated for 6 areas...

Thanks for your help
Bryce


1-Feb Youth Leaders Meeting
9-Feb Specific Meeting
TBA Serving & Leading Seminar
23-Feb Social or Youth Activity
25-Feb Divine Service

1-Mar Youth Leaders Meeting
9-Mar Specific Meeting
23-Mar Social or Youth Activity
25-Mar Youth Service - Henderson

5-Apr Youth Leaders
13-Apr Specific Meeting
TBA Serving & Leading Seminar
20-Apr Social or Youth Activity
26-Apr Youth Leaders - 7.30PM
29-Apr Youth Service - Howick


"Andy Brown" wrote:

"srpingbokiwi" wrote in message
...
i am drawing up a schedule for Jan to Jun 2007. I need to schedule a
meeting
every 1st thursday of the month.

Assuming your 07 dates (commencing 1st Jan) are in A1:A212, enter this
formula in B1:

=AND(DAY(A1)<=7,WEEKDAY(A1)=5)

and copy it down.

Then copy column B and Edit Paste Special Values. And use Replace
(CTRL+H) to replace FALSE with nothing and TRUE with (example) "Monthly
meeting".

Note: you'll probably need the Analysis Toolpak installed (under Tools
Options) to utilise the WEEKDAY function.