First, I would check to see if this variation of your formula:

=SUMPRODUCT(--(text(Data!F2:F65536,"yyyymm")="200801"))

counted the number of contractors hired in Jan of 2008.

And this

=SUMPRODUCT(--(text(data!G2:G65536,"yyyymm")="200801"))

counted the number of permanent employees that started in Jan of 2008.

I think this formula is easier to read, but will be equivalent to each portion

in your original formula.

And as an aside, if you can pick a smaller number of rows to check, your

calculation times will be better.

But I'm not sure doing the subtraction will get you what you want. If I was

hired as a contractor in August of 1967 and made permanent in January of 2008,

then I'll be counted in that second formula.

If you want to limit your count to just the people hired as contractors in Jan

2008 and converted to permanent employees in Jan of 2008, I think just adding

more conditions to the =sumproduct() should work:

=SUMPRODUCT(--(text(Data!F2:F65536,"yyyymm")="200801"),

--(text(data!G2:G65536,"yyyymm")="200801"))

Both of these conditions have to be true for it to be counted.

DAve,

Your explanation makes sense. thanks, but let me pick your genius brain one

more time. If I find my answer using your solution of how many people were

hired as contractors,

=SUMPRODUCT(--(MONTH(Data!F2:F65536)=1),--(YEAR(Data!F2:F65536)=2008)) how

would i then find out how many of those were converted to permanent employees

in the same date range. They might be hired as a contractor and stay that

way for several months or they could be permanently hired within the same

month. I tried

=(SUMPRODUCT(--(MONTH(Data!F2:F65536)=1),--(YEAR(Data!F2:F65536)=2008))-SUMPRODUCT(--(MONTH(Data!G2:G65536)=1),--(YEAR(Data!G2:G65536)=2008)))

but get the wrong answer.