Years included in range

Hi,

I need to build a formula that will tell me in which years an employee was employed.
I think it involves some IF AND nesting formula and some extra columns.
I figured I'd add a column for each of the possible years i.e. 2000, 2001, 2002.. and have it add a 1 to that column if they were employed during that year.
Then I can see the totals of employees during that year with an easy sum at the bottom of the sheet.

I'll attach a worksheet of data. "tempDateRange"
You can see what I'm trying to do there.

I got it started but it does not include all the employed dates in the table. Need more criteria.

I29:I37 contain 2000,2001,....,20007
In J29, then drag down
=SUMPRODUCT(--(YEAR($B$2:$B$30)=I29))

FDibbins. Your answer solved my problem. Thank you for your help.
I attempted to add reputation to your answer.
Let me know if it didn't go through.
Thanks.