• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

excel pivot columns to cross years

I have an excel table with an invoice date field. I would like to format this field or another using this field in a MMYY format. The purpose being to create a slicer for columns of data to cross years. example: select 1112; 1212; 0113; 0213 would create a pivot with cumulated data with 4 columns spanning 1112 to 0213. Is this possible?
0
actsoft
Asked:
actsoft
1 Solution
 
usachrisk1983Commented:
If it's in date format in the cell, you can create a second column that has the formula:

=Year(A1) & "-" & Month(A1)

Open in new window


You can pull out the "-" if you don't want the hyphen there, and you'll want to replace A1 with the cell you're trying to reformat.
0
 
actsoftAuthor Commented:
Thanks, I was trying to make it much more complicated than necessary.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now