jay_hl
8th Sep 2006, 20:56
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 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