Change full date to month only

J

Jim

Hello,

What formula can I use to pull out the month only on a date formatted as
follows:

3/28/2009

I know I can re-format the cell but I am interested in help with a formula

Thanks
Jim
 
J

Jacob Skaria

You can also use....and adjust the format to your need.
=CHOOSE(MONTH(A1),"JAN","FEB","mar","apr","may",............,"DEC")

If this post helps click Yes
 
F

Francis

try this
if you want the month to appear as numeric
=MONTH(A2)

or Mar in your example
=TEXT(A8,"mmm")
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
Top