Now() Function...Help Needed

B

Brad W

I have 2 columns in this worksheet that I need help with. I am trying to set
it up where when a value is entered into column A, the date & time will
automatically fill in column B. Here's the formula I'm using
=IF(A1="","",Now()). However, I need for the date/time info to remain
constant. Is there anyway to make Now() a non-volatile function?
 
N

Niek Otten

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have 2 columns in this worksheet that I need help with. I am trying to set
| it up where when a value is entered into column A, the date & time will
| automatically fill in column B. Here's the formula I'm using
| =IF(A1="","",Now()). However, I need for the date/time info to remain
| constant. Is there anyway to make Now() a non-volatile function?
 
Top