Converting Date 03/01/2010 into a simple Month

[Kennedy]

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.

 

[T. Valko]

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

 

[trip_to_tokyo]

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

 

[FSt1]

hi
=month(a2)

will return 3 (third month)

Regards
FSt1

 

[Paul C]

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

This will return display as Mar for 3/1/2010

 

[FSt1]

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

regards
FSt1

 

[FSt1]

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

 

[FSt1]

ignore the above. posted to wrong post.

sorry
FSt1

 

[Kennedy]

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