$E$1 value is 4/14

Date New Prod Extension Transfer
4/14 0 0 0
4/15 0 0 0
4/16 0 0 0
4/17 0 0 0
4/18 0 0 0

If the product is "In Process" and it is a "New Prod" and since today's
date is 4/14, it will count in the top left. Next day will be 4/15, and
$E$1 will automatically change and the data will now be summaized on the
second row.


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