View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yhoy yhoy is offline
external usenet poster
 
Posts: 27
Default How to show only Month of a mm/dd/yyyy format?

I have two columns of data in format of mm/dd/yyyy. How do I convert so it
shows only "mmm"? And, is there an easy way to set up range as "1/1/2008" -
"1/31/2008" in pivot table?

Thanks...