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

B

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

T. Valko

If you want the month name:

Short name format: Jan

=TEXT(A1,"ddd")

Long name format: January

=TEXT(A1,"dddd")
 
T

T. Valko

Ooops!
Short name format: Jan
=TEXT(A1,"ddd")
Long name format: January
=TEXT(A1,"dddd")
Click to expand...

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Doughnut Chart linked with the slicer in the pivot table 0
Formula to Look up values from a pivot table 1
How to change date format to 7 working days a week in ms project 2010? 0
counting weeks in current month. 1
number of months and days between two dates without approximation 3
Excel date question 0
Can an If statement return a formula for false? 1

Top