Is there a formula that will return only the month from a date?

[birdgirl31]

I have a column with dates. I want to put a cell with a formula beside each
date that will return the month. I know I can do this with formatting but I
want to use the "month" column in a pivot that will let me sort my data by
month. When I just return the date value and change the formatting to show as
month, the pivot still reads the "month" cells as a day.

 

[Joel]

Use formula = month(A1)

 

[T. Valko]

If you want the month name:

Short name format: Jan

=TEXT(A1,"ddd")

Long name format: January

=TEXT(A1,"dddd")

 

[T. Valko]

Ooops!

Short name format: Jan
=TEXT(A1,"ddd")
Long name format: January
=TEXT(A1,"dddd")

Those formulas will return the weekday. These are the correct formulas:

=TEXT(A1,"mmm")
=TEXT(A1,"mmmm")

 

[birdgirl31]

Thanks to you all - your formulas worked perfectly!

 

[T. Valko]

You're welcome. Thanks for the feedback!