Help! count table with dates

[aodhan]

Hi, I am trying to get a very large table to provide countable (0 or 1) or markable "X"
calendar year columns to get data for graphing #sites/calendar year. The table contains, for
example:

Location: start date exp date 2006 2007 2008 2009 2010 2011
alpha 2/2/06 2/2/09 x x x x
beta 10/11/09 10/11/11 x x x
etc; SUM=

I have tried using date <= or >= vlookup() and If() to utilize start/exp dates to count/mark
the calendar year with 1/1/'year' and 12/31/'year'. I can get the start year and expire year
to mark. But I am having tough time getting the intervening years to count/mark.
Thank you.

 

[AlphaFrog]

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Location:	start date	exp date	2006	2007	2008	2009	2010	2011
2	alpha	2/2/2006	2/2/2009	1	1	1	1	0	0
3	beta	10/11/2009	10/11/2011	0	0	0	1	1	1
Sheet1

Excel 2002

Cell Formulas
Range	Formula
D2	=IF(AND(YEAR($B2)<=D$1,YEAR($C2)>=D$1),1,0)
D3	=IF(AND(YEAR($B3)<=D$1,YEAR($C3)>=D$1),1,0)
E2	=IF(AND(YEAR($B2)<=E$1,YEAR($C2)>=E$1),1,0)
E3	=IF(AND(YEAR($B3)<=E$1,YEAR($C3)>=E$1),1,0)
F2	=IF(AND(YEAR($B2)<=F$1,YEAR($C2)>=F$1),1,0)
F3	=IF(AND(YEAR($B3)<=F$1,YEAR($C3)>=F$1),1,0)
G2	=IF(AND(YEAR($B2)<=G$1,YEAR($C2)>=G$1),1,0)
G3	=IF(AND(YEAR($B3)<=G$1,YEAR($C3)>=G$1),1,0)
H2	=IF(AND(YEAR($B2)<=H$1,YEAR($C2)>=H$1),1,0)
H3	=IF(AND(YEAR($B3)<=H$1,YEAR($C3)>=H$1),1,0)
I2	=IF(AND(YEAR($B2)<=I$1,YEAR($C2)>=I$1),1,0)
I3	=IF(AND(YEAR($B3)<=I$1,YEAR($C3)>=I$1),1,0)

 

[aodhan]

Thanks AlphaFrog & Mr Excel. I feel so dense .