Hi,
This is a little verbose but it will give you the month and year of a date...
you can then do your analysis on this column.
=LOOKUP(MONTH(A15),{1,2,3,4,5,6,7,8,9,10,11,12},{" January","February","March",
"April","May","June","July","August","September"," October","November",
"December"})&" "&YEAR(A15)
If you don't care about having January then simple =month(A15)&" "&YEAR(A15)
will work.
HTH
Simon
pobm62 wrote:
Hi,
This is my first post but I want to thank everyone who has posted before me
as I have been able to learn so much from previous questions.
I have a column in a spreadsheet (H7:H129) that covers a range of dates -
and these dates can go across more than one year. I have learnt how to count
the number of times a certain month appears but now I want to count the
months dependent on the year, eg count how many entries there are for July
2006, September 2006, November 2006 etc.
This spreadsheet will be used for years into the future so I want it to
automatically read the year from the worksheet. There is already a cell in
the worksheet where the date is manually inserted at the start of the month.
It displays as mmm-yy.
Any assistance will be greatly appreciated.
Thanks in advance.
--
--------------------
Simon - UK
Email at simon22mports [ a t ] hot mail [ d ot ]com
Message posted via
http://www.officekb.com