Changing date to eliminate day in format mm/dd/yyyy

V

VA

Assistance with removing day from date format. Wish to change column of
dates which are in format mm/dd/yyyy to new value yyyy-mm. Converted dates
in column are then to be used in a pivot table, to sort data by monthly
occurances. The pivot table presently sorts by daily occurances as the date
is in mm/dd/yyyy format.
 
D

Dave Peterson

I wouldn't do it.

It sounds like you can group your data in the pivottable by month and year and
have exactly what you wanted.

But you could use a formula like:
=text(a1,"yyyy-mm")
to do the conversion.

(But try that grouping in the PT first. You'll like it.)
 

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

yyyy-mm-dd date format? 3
reformat dates to yyyy/mm/dd 5
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
Sumproduct and weekday from mm/dd/yyyy format? 3
change date format from dd/mm/yyyy to mm/yyyy 2
How to convert MM/DD/YYYY to Month 2
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1

Top