Define "a month ago". For example, what **date** would you consider a month
ago from today? Also, what **date** would you consider a month ago if
today's date were October 31, 2007?

Rick


"Ken" wrote in message
...
David, Rick, Smiley,
My problem is similar. I need to calculate the count of entries that
lie-- 1.
btwn today and 1 mnth ago, 2. btwn 1 mnth ago and 3 mnths ago, 3. btwn 3
mnths ago and 6 mnths ago, 4. btwn 6 and 9 mnths ago and 5. greater than 9
mnths ago.
All entries have a date associated with entry in colmn C.
Thanks ahead of tme.


"Teethless mama" wrote:

=SUMPRODDUCT(--(MONTH(A2:A100)=3),--(YEAR(A2:A100)=2007))
or
=SUMPRODUCT(--(TEXT(A2:A100,"m/yy")="3/07"))


"GeorgeG" wrote:

Hi there,

I'm trying to create a formula that counts the number of times an event
occurs for any given month, each year. For exmaple, i'd like to count
the
number of times an event occurs in March 2007, March 2006, etc. The
dates
stored on my spreadsheet are in the form of dd/mm/yyyy.

Any help would be greatly appreciated!
Cheers