Well, I ran into a couple of problems with this formula. For the 200+ rows
Im applying it in, theres a handful that arent calculating right. For
example, Ill have a date range of :

10/01/01 thru 02/28/02

And the result for the 06/30/02 column is 8, when it should be 5

Some more a

09/01/04 thru 05/31/05 = 11 in 06/30/05 column, when it should be 9
01/01/04 thru 01/31/04 = 7 in 06/30/04 column, when it should be 1
02/01/04 thru 03/31/04 = 9 in 06/30/04 column, when it should be 2

Im not sure where to begin on editing the formula.

Thanks.


"Rowan Drummond" wrote:

Glad to hear it worked.

Regards
Rowan

Corey wrote:
Nevermind...it just seemed to work that way for a date that ended on 06/30.
By changing the formula to = it solved the problem. Thanks so much for
this...I never would have got it.

"Corey" wrote: