View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KK KK is offline
external usenet poster
 
Posts: 61
Default Display dates as months

Hi,

I have a range of dates such as:
3/19/2003
3/20/2003
3/20/2003
3/20/2003
3/21/2003
3/21/2003
3/21/2003
I need this to be converted in the Mar-03 format and do away with the
individual dates so that I can use it for a pivot table. The above is only an
example as I have 40,000 entries as above all various months.