A thousand thank yous!!!! You have no idea how much time this will save me.

Have a great weekend!
Sandi

"Dave O" wrote:

Hi, Sandi-
I mocked up some sample dates in a3:a11028, and entered 5/25/2008 in
cell g3. In cell h3 I used a formula to find the end date:
=EDATE(G3,12)-1 (Note: if this formula returns an error, on the menu
click Tools Add-ins, then check the box next to Analysis Toolpak and
click OK.) In cell g4 I used a formula to create the next year's start
date: =H1+1 and I copied the formula from h3 into h4. You can copy
the range g4:h4 and paste it down for as many rows as you need.

In cell i3 I developed a count of install dates with the formula
=SUMPRODUCT(--($A$3:$A$1028=G3),--($A$3:$A$1028<=H3))

Here's an explanation of the double unary operator:
http://groups.google.com/group/micro...145474b68429fc

Dave O
Eschew obfuscation