If I use the NOW function for problem two, wont the returned dat
constantly be changing? I want the returned date to be static to th
day that the record is "complted" (list box)

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=31455

Hi
this is only possible with VBA or manually inserting the value/date. See:
http://www.mcgimpsey.com/excel/timestamp.html

"Mcasteel" wrote:


If I use the NOW function for problem two, wont the returned date
constantly be changing? I want the returned date to be static to the
day that the record is "complted" (list box).


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=314556