http://www.mcgimpsey.com/excel/timestamp.html

just change now to today

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"dps9460" wrote in
message ...

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