OK, its the last part causing a problem, I don't think I understand your
intent. what do you mean A3 contains each day of the year?

As the formula stands you'll always get zero unless
NewProduct2006!$E$1=$A3, i.e. A3 must contain today's date. Clearly
that isn't what you want, are you looking at a date cell on every row?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=533060