"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.