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.

Converting a Numeric Date into a Single Month Function in Microsoft Excel

Yes, there is a way to convert a numeric date into a single month function in Microsoft Excel. You can use the MONTH function to extract the month from the date and display it in a separate cell.

Here are the steps to do this:

1. Select the cell where you want to display the month.
2. Type the following formula: =MONTH(A1)
3. Replace "A1" with the cell reference of the date you want to extract the month from.
4. Press Enter.

The result will be a number representing the month (e.g. 3 for March). If you want to display the month name instead of the number, you can use the TEXT function to format the result.

Here's how to do it:

1. Select the cell where you want to display the month name.
2. Type the following formula: =TEXT(A1,"MMMM")
3. Replace "A1" with the cell reference of the date you want to extract the month from.
4. Press Enter.

The result will be the full name of the month (e.g. March).

You can also use other date formats with the TEXT function to display the month in a different way. For example, =TEXT(A1,"MMM") will display the abbreviated name of the month (e.g. Mar).

One way...

A1 = a date like 03/01/2010

B1 formula:

For the short month name like Mar

=TEXT(A1,"mmm")

For the long month name like March

=TEXT(A1,"mmmm")

--
Biff
Microsoft Excel MVP


"Kennedy" wrote in message
...
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.

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

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.

If you don't want a numeric display use a custom number format mmm.

This will return display as Mar for 3/1/2010
--
If this helps, please remember to click yes.


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

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.

hi
i think dave peterson answered your question about 10 posts ago.
find and replace.
press Ctlr+F
click the replace tab.
in the find box enter . (dot)
in the replace box enter : (colon)
click replace all

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.

ignore the above. posted to wrong post.

sorry
FSt1

"FSt1" wrote:

hi
i think dave peterson answered your question about 10 posts ago.
find and replace.
press Ctlr+F
click the replace tab.
in the find box enter . (dot)
in the replace box enter : (colon)
click replace all

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.

Thanks everyone for the advice. I think the issue may have been with the fact
that the column was being pulled from another sheet source. So between
everyone's suggestion, was able to use =text(column,"MMM") and it worked
perfectly. Thanks again for all of the input...and I rated all the replies

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