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.

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.)

VA wrote:
>
> 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.

--

Dave Peterson