=MONTH(A1)

Will give you the month (in the form of a number).

A1 is the cell where you have the date.

Please hit Yes if my comments have helped.

Thanks.

"Kennedy" wrote:

Is there a way to convert a numeric date 03/01/2010 into a single month
function? I have a worksheet that pulls in data from another worksheet, and
column A has a numeric date of 03/01/2010. Want to put a statement in column
B or where that only shows the month instead of the whole date field.