View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Working with Dates: Calculating A Running Total for Days Held

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