question about converting date format and pivoting

[ces005]

Hi,

If I have a dates in a table like 02/01/06, 02/10/06, etc. but want the date to be converted to 02/06 and 02/06 and then pivot on it this way, how do I do this? When I converted the format and then pivoted, these two entries appeared as two separate entries in the pivot table since the pivot table still treated these dates as being different but I want them to be treated as the same value.

-Eileen

 

[ces005]

John,

The code you gave to me works very well.

Thanks a lot.

Are there any Excel books or web sites you would recommend? I am writing scripts, but am sure that I am not writing them with good style, they are not efficient, and they may not be that robust.

-Eileen

 

[Datsmart]

Take a look at the offerings in the on line store of the web site for books.
http://www.mrexcel.com/sunshop/
This forum is the best I have seen as far as web sites to learn about Excel.
Here are a few others I have learned from:
http://www.contextures.com/tiptech.html
http://www.puremis.net/excel/
http://peltiertech.com/index.html
http://www.tushar-mehta.com/