Yes, both formulas worked--thank you! The data is all from 2001-2007, from
each month of those years. So, there's lots of it, but all from years in
which the "2000+" bit of your lovely formulas works perfectly.

Thanks again,

lisa

"Rick Rothstein (MVP - VB)" wrote:

Ah, so you did... I didn't read the text of your message... I just looked at
the formula you included.

Rick


"T. Valko" wrote in message
...
I noted that in my reply and the OP seems to be satisfied!

--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
.....the two datasets; they were created over years...

Over years? How many years? If more than 7, then the formulas Biff and I
supplied you will have to be modified... we both assumed all dates
happened in 2000 or later.

Rick