hi
to prevent confusion on my last post.
for today =Month(A2) will return 3 (for third month-Mar)

regards
FSt1

"FSt1" wrote:

hi
=month(a2)

will return 3 (third month)

Regards
FSt1

"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.