Turn 5 on or Between 2 Dates

[anthonyexcel]

I need to put an x if the child turns 5 or greater than on or inbetween these 2 dates 1/2/2011 and 1/1/2012. I think that I have figured it out. Is there another approach I should have taken?

Thanks in advance Anthony



******** ******************** src="<A href='http://www.interq.or.jp/sun/puremis/colo/popup.js">*********><CENTER><TABLE' target=_blank>http://www.interq.or.jp/sun/puremis/colo/popup.js">*********><CENTER><TABLE< a>cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" colSpan="5" bgColor="#0c266b"><TABLE border=0 width="100%" align=center><TBODY><TR><TD align=left>Microsoft Excel - Book1</TD><TD style="FONT-FAMILY: caption; COLOR: #ffffff; FONT-SIZE: 9pt" align=right>___Running: 14.0 : OS = Windows XP </TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px; BORDER-RIGHT: #000000 0.5pt solid" colSpan="5" bgColor="#d4d0c8"><TABLE border=0 width="100%" align=center VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-FAMILY: caption; COLOR: #000000; FONT-SIZE: 10pt">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</TD><TD vAlign=center align=right><FORM name=formCb605117><INPUT value="Copy Formula" type=button name=btCb942116 *******='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);'></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" colSpan="5" bgColor="white"><TABLE border=0><TBODY><TR><FORM name=formFb202339><TD style="WIDTH: 60px" bgColor=white align=middle><SELECT onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name=sltNb447362><OPTION selected value='=IF((DATEDIF(A2,"1/2/2011","y")>=5)+(DATEDIF(A2,"1/1/2012","y")>=5),"x","")'>B2<OPTION value='=IF((DATEDIF(A3,"1/2/2011","y")>=5)+(DATEDIF(A3,"1/1/2012","y")>=5),"x","")'>B3<OPTION value='=IF((DATEDIF(A4,"1/2/2011","y")>=5)+(DATEDIF(A4,"1/1/2012","y")>=5),"x","")'>B4<OPTION value='=IF((DATEDIF(A5,"1/2/2011","y")>=5)+(DATEDIF(A5,"1/1/2012","y")>=5),"x","")'>B5<OPTION value='=IF((DATEDIF(A6,"1/2/2011","y")>=5)+(DATEDIF(A6,"1/1/2012","y")>=5),"x","")'>B6<OPTION value='=IF((DATEDIF(A7,"1/2/2011","y")>=5)+(DATEDIF(A7,"1/1/2012","y")>=5),"x","")'>B7<OPTION value='=IF((DATEDIF(A8,"1/2/2011","y")>=5)+(DATEDIF(A8,"1/1/2012","y")>=5),"x","")'>B8<OPTION value='=IF((DATEDIF(A9,"1/2/2011","y")>=5)+(DATEDIF(A9,"1/1/2012","y")>=5),"x","")'>B9<OPTION value='=IF((DATEDIF(A10,"1/2/2011","y")>=5)+(DATEDIF(A10,"1/1/2012","y")>=5),"x","")'>B10<OPTION value='=IF((DATEDIF(A11,"1/2/2011","y")>=5)+(DATEDIF(A11,"1/1/2012","y")>=5),"x","")'>B11<OPTION value='=IF((DATEDIF(A12,"1/2/2011","y")>=5)+(DATEDIF(A12,"1/1/2012","y")>=5),"x","")'>B12<OPTION value='=IF((DATEDIF(A13,"1/2/2011","y")>=5)+(DATEDIF(A13,"1/1/2012","y")>=5),"x","")'>B13<OPTION value='=IF((DATEDIF(A14,"1/2/2011","y")>=5)+(DATEDIF(A14,"1/1/2012","y")>=5),"x","")'>B14<OPTION value='=IF((DATEDIF(A15,"1/2/2011","y")>=5)+(DATEDIF(A15,"1/1/2012","y")>=5),"x","")'>B15<OPTION value='=IF((DATEDIF(A16,"1/2/2011","y")>=5)+(DATEDIF(A16,"1/1/2012","y")>=5),"x","")'>B16<OPTION value='=IF((DATEDIF(A17,"1/2/2011","y")>=5)+(DATEDIF(A17,"1/1/2012","y")>=5),"x","")'>B17<OPTION value='=IF((DATEDIF(A18,"1/2/2011","y")>=5)+(DATEDIF(A18,"1/1/2012","y")>=5),"x","")'>B18<OPTION value='=IF((DATEDIF(A19,"1/2/2011","y")>=5)+(DATEDIF(A19,"1/1/2012","y")>=5),"x","")'>B19</OPTION></SELECT></TD><TD bgColor=#d4d0c8 width="3%" align=right>=</TD><TD bgColor=white align=left><INPUT value='=IF((DATEDIF(A2,"1/2/2011","y")>=5)+(DATEDIF(A2,"1/1/2012","y")>=5),"x","")' size=80 name=txbFb150492></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align="middle" width="2%">
</TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align="middle"><CENTER>A</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align="middle"><CENTER>B</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align="middle"><CENTER>C</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align="middle"><CENTER>D</CENTER></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>1</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: left; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid">BirthDate</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: left; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid">Turn 5</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid"> </TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>2</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">2/7/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>3</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">2/7/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>4</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">2/6/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>5</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">2/6/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>6</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">1/1/2007</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">x</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"> </TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>7</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">2/4/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>8</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">10/28/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>9</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">10/23/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>10</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">10/21/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>11</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">10/17/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>12</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">11/9/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>13</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">11/5/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>14</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">11/5/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>15</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: middle; BORDER-RIGHT: #000000 0.5pt solid">11/5/2008</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>16</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">1/2/2006</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">x</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"> </TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>17</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">1/2/2006</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">x</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"> </TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>18</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">1/3/2007</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">
</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" align="middle" width="2%"><CENTER>19</CENTER></TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">12/29/2006</TD><TD style="BORDER-BOTTOM: #000000 0.5pt solid; TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">x</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid"> </TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Cambria; COLOR: #000000; FONT-SIZE: 9pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid"></TD></TR><TR><TD style="BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; BORDER-TOP: #808080 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" colSpan="5"><TABLE width="100%" align=left VALIGN="TOP"><TBODY><TR><TD style="BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; WIDTH: 120pt; BORDER-TOP: #808080 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=left>Sheet2</TD><TD></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>

 

[Gerald Higgins]

There are lots of other approaches you could have taken, which are not necessarily better than what you've done.

For example something like this

=if(and(a2< date(2007,1,1),a2> date(2006,1,1)),"X","")