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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template with fields and premade texts.. 0
need help with function 4
Excel - Wich Function should I use? 1
Help needed regarding calculating time 0
Getting a formula to reflect added columns 10
VBA Coding Help for Beginner 0
Need Help with a VBA subroutine 0
Calculate end date and time 1

Top