Can someone assist me with this. If I place a "Y" into column 2
(Tested), I would like "Today's Date" to show in the "Date" column.
When Today's Date changes to the next day I want the previous dates
(Column 1) to stay. Can someone help. I'm having a rough time and I'm
sure it's pretty simple.




Today's Date

6/2/2006

Column 1 (Tested) Y (Date) 6/1/2006
Column 2 (Tested) Y (Date) 6/2/2006


--
dps9460
------------------------------------------------------------------------
dps9460's Profile: http://www.excelforum.com/member.php...o&userid=14725
View this thread: http://www.excelforum.com/showthread...hreadid=548038