Find out who's birthday it maybe today()

Try this...
Enter array formula in cell C3 and copy down

Formula:

=IFERROR(INDEX(B:B,SMALL(IF(A$3:A$12=$B$2,ROW(A$3:A$12)),ROWS(C$3:C3))),"")

**Must be entered with Ctrl+Shift+Enter key combination.

I think that it would be better just to have Month and Day as text and Col A and TODAY() should be as text as well

Formula:

=TEXT(TODAY(),"mmm-dd")

v	A	B	C
1		Today's Date
2	B-Day	Jun-14	Today's Birthday
3	Jun-15	John	Jim
4	Jun-16	Steve	Mellisa
5	Jun-14	Jim
6	Jun-18	Lisa
7	Jun-19	Kate
8	Jun-20	Paul
9	Jun-14	Mellisa
10	Jun-22	Silvia
11	Jun-23	Jerry
12	Jun-24	Kate

If date of birth in column "A"
In column "B2"

Formula:

=IF(ISERR(DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)),"d")),IF(AND(DATEDIF(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)),TODAY(),"d")<=2,WEEKDAY(TODAY(),2)=1),"The last weekend",IF(AND(MONTH(A2)=1,MONTH(TODAY())=12),DATEDIF(TODAY(),DATE(YEAR(TODAY())+1,MONTH(A2),DAY(A2)),"d"),"Not soon enough")),IF(DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)),"d")<61,IF(TODAY()-DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))=0,"Happy birthday",DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)),"d")),"Not soon enough"))

copy down till your range.