View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yuanhang Yuanhang is offline
external usenet poster
 
Posts: 28
Default Summarizing Dates into Months and Years

Hey, assume I have column A like that as followed:

Column A
12/11/07
1/07/08
2/13/08
2/13/08
3/11/08

Basically, column A are some dates sorted ascendingly. They could be in
different years or they might be at the same date sometimes.

So, is it possible to let Excel create a new column by picking up different
months and years but ignore the dates. Basded on comlumn A above, if
possible, column B gonna look like:

Column B
Dec., 2007
Jan., 2008
Feb., 2008
March., 2008