Converting a date field into a month-year only field

G

Guest

I have a column of dates that are populated with xx/xx/yyyy and I would like
have another column that takes the date of the particular month & year and
combine it to be recognized only as a month-year data cell. I am trying to
do this so my pivot table will combine all of the dates within a certain
month into a common total cell.
 
D

Dave Peterson

Maybe you could use another column with formulas like:
=text(a2,"yyyymm")

If you really wanted to just worry about the month and ignore the year:
=text(a2,"mm")
or just
=month(a2)

===
But before you do this, you may want to rightclick on that field in the
pivottable and choose Group and show detail. Group by Month (or month and
year).

Each of the entries in that field in the raw data has to be a date--no text, no
empty cells.
 

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

Top