Make a Calendar with noted Birthdays, etc...

Hello, Excel experts,

I've looked at Lots of calendar templates... can't find what I want.

Using Excel 2007, I'm trying to print a calendar for any year.
The calendar itself is pretty simple...
the tricky part is getting my friend's Birthdays to appear.

Attached is what I've got so far.

How can I get the text to appear on the correct date?

Thanks, in advance.

Mark53

Well, Alan...
Thanks for your reply, but I really have no idea how to do what you said.
And... I want to set this up for the entire year, not just a few weeks.

OK... I looked up VLOOKUP.
Never worked with it before. Seems fairly straight-forward.
In order to get the results into cell D13,
I'd take the Month and Day from C13, and VLOOKUP that?
How do I Vlookup BOTH the Month AND the Day?
That is... how do I match the Month AND THEN ALSO match the Day?

And... what if there's more than 1 birthday on January 5?
If I just use the same formula in cell D14, I'll get Joe again.

I'm assuming I'd put the same formula into Every date in the calendar... yes?

I've also never worked with IFERROR.
But I think I can figure that out.

I've attached a new file, with the beginnings of the Tables you suggested (I think).

Thanks for your help.

Oh, Alan,... WE are Good !
I'm sorta' giggling like a schoolboy here.... quite proud of myself.
I'm tellin' ya'... with your help, I'm a genius !

Waitaminute... Are you referring to using the Outlook (EMAIL?) program?
I don't use MS Outlook. I'd Really rather use Excel for this.

OK... first... because of Printing requirements,
I decided to put each 5 1/2 X 8 1/2 sheet on a separate worksheet page.
Not a big deal.

Next... please look at what I did with cell B25 on sheet W2.
I tried to condense the "programming?" into the one cell.

Now...
Notice column E on the Dates sheet.
Can we use that as sort of a "worker" column?
(I think that's what I've heard them called before.)
So... we'd change that to a "1" whenever that Row is used.
How can that be done?
And then... How do we Ignore any Rows that have a "1" in that "used" column?
Before going to Print a calendar, I'd reset all of those to "0".

And another question...
How can I make that info in B25 print RED?
(Remember, later, I will want to print all Anniversaries in Blue.)

Thanks.

More progress:
I got the Red text to appear...
Conditional formatting:
If the text contains " is ", then make it Red !
Cool !

And if it contains ":", then make it Blue !

This is gonna' be Great !

There Might be multiple Birthdays on one date.
Therefore, I'll put the same formula on B25 and B26 and B27.
IF the Vlookup FINDS a Birthdate to print on B25 (like Brad's),
then I want to eliminate (Brad's) birthday from printing again on B26.
I will want the same formula to find DAVE's birthday to print on B26.

So, have Vlookup work ONLY on rows that have Row E set to "0".
When Vlookup finds Brad, set Brad's Row E to "1".

How can that be done?

Please see the updated file.

Thanks, Alan.