View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
line line is offline
external usenet poster
 
Posts: 6
Default macro to make current date remain fixed

Hi,
I want to insert a current date into a cell, but then to have that date
remain fixed. Basically, Im using an IF function to create a date in a cell
along the lines of IF(A2801000000000,NOW()). The current date fills the
cell, but then changes the next day because of the internal clock.

Ideas?