Turning date into month

  • Thread starter Thread starter Thore
  • Start date Start date
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
 
Pivot tables allows you to group by month, but, if you want to...

=MONTH(A1)

or

=TEXT(A1,"mmm")
 
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...
 
hI

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

HTH. Best wishes Harald
 
Back
Top