matching a date with a month

i have spreadsheet that submits a date, but on another sheet i need to find if the dat on the date a sheet is in a certian month
i.e
24/10/2008
is in the month of october 2008
how can i do this

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

Maybe =TEXT(A1, "mmmyyyy") = "Oct2008"

thanks that helps
if i use this formula how can add in the formula to add the sum of a row