excell 2003 dates question

[frozen.ice]

Hi all

I have trouble figuring out how to solve a problem. If I have a collum of dates of birth, what formula could I use to see all the people born in june for instance. Dates seem to be stored in a code form, so the regular =if(D2="*/06/*","true","0") doesn't work. Is there any way?

Thanks

 

[ITCynic]

Use the MONTH() function to get the numeric value of the month from the date and then evaluate the result. =MONTH(B2) where "B2" = date string