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?
Who is Participating?
usachrisk1983Connect With a Mentor Commented:
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.
actsoftAuthor Commented:
Thanks, I was trying to make it much more complicated than necessary.
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.

All Courses

From novice to tech pro — start learning today.