I have downloaded abot 20,000 lines of data. One of the columns in the data
is a date field. The dates begin in 2004 and continue through 2008. The dates
in the downloaded file would look like this 06/25/04 so on and so on. I want
to be able group the data in a pivot table by month and year. The only way I
have been able to think to do this is to open a new column and change the
06/25/04 date to read 06/01/04. This would allow me then to report inside a
pivot table for the month of June 2004. IS there a simpler way to do this
without having to create a new column or is there a way to simply change the
DAY for all date ranges to be 01?