On Sat, 6 Aug 2005 01:13:01 -0700, mcraig
wrote:

please can someone help me with the following

i wish to find out from a list of students names and dob, when a students
birthday is due

example
column 1 column 2
name dob
fred smith 12/1/1985

i need a formula to tell me whos birhtday is due in a specific month and on
what date so i can send out a card

I'm not quite sure whether I understand your question, but if I do the
following may do what you want:
In column 3 (C), put the formula =MONTH(B1)
In column 4 (D), put =DAY(B1)

Now go to Data menu - Filter - Autofilter.

You can select the month that you want from column C. Column D will
then show you the dates on which birthdays occur for that month.

(There are other ways of doing this, but the method above makes the
results nice and obvious.)

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *