I want to put in a value in a cell by identifying only the month from a given date on one excel worksheet and match it with only a month from a given date on another excel worksheet

The function month(A1) returns the month of a date in cell A1, as a number 1 through 12. So if the cell A1 has the date Feb 3 2009, then month(A1) returns the number 2.

If you want to match data between separate worksheets you need to prepend the worksheet name. So month(sheet1!A1) returns the month of the date contaned in cell A1 of worksheet "sheet1."