Turning date into month

T

Thore

Hi all,

I have a column full of dates. I would like to add a
column that shows in which month each date falls. Simply
changing the display format does not work because I need
to create a pivot table which then shows orders per month
etc.
How do I do that?

Thanks in advance,
Thore
 
A

Aladin Akyurek

Pivot tables allows you to group by month, but, if you want to...

=MONTH(A1)

or

=TEXT(A1,"mmm")
 
T

Thore

Thanks to both of you for the quick reply.

How do I group within the pivot table?

-----Original Message-----
Pivot tables allows you to group by month, but, if you
Click to expand...
want to...
 
H

Harald Staff

hI

Rightclick the field header. There's a Group menu with a wizard.

HTH. Best wishes Harald
 

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

Excel does not accept text format! 0
use month in cell date to sum all relevant cells 2
If Formula and Dates 4
Style Gallery View 3
Counting multiple occcurrences between date range 3
Dealing with a Pivot Table (when I don't want to) 0
Word VBA - Want to test if Full Name is NOT Present in document 0
How to sum by month 8

Top