Excel dat help
 

Guys n gals,

I have a very basic spreadsheet that has various dates down the left hand side. I am looking for a formulae the returns that summarises the data and returns the month that the date is in.

Eg

01/06/2006
21/06/2006
02/06/2006
05/07/2006
08/08/2006

I could like a table next to the data to say:

June 3
July 1
August 1
etc

I think its simple but am having a serious memory lapse. Too many beers on a Friday night i suppose!! :rolleyes:

Cheers

I too have a little memory lapse, but i think this is simply a formatting solution. Format the day in the format you want, enter 1/1/2007, get 1st Jan 2007. Or if you want 01.01/07 and 1st jan 2007 next to each other make the next colum a replicar of the previous one and just change the formatting. I have just tryed it and it works, suppose there is a right way to do this, or a better way but i cant think, and its been years since i studdied excel...

Nice solution but i could actually do with the data displayed in a table so that i can do various things with it!!

Anybody else, any ideas????

XL Formula
 

If anyone wants to know I have devolped the following formula which seems to do the job.

=CHOOSE(ROW(),"Jan","Feb","Mar","Apr","May","Jun", "Jul","Aug","Sep","Oct","Nov","Dec")&" "&SUMPRODUCT(--(MONTH(($A$1:$A$30))=ROW()))

This first bit is for displaying the month in short in the first 12 rows only.

Rgds