Prevent Date Recalculating

  • Thread starter Thread starter Jeff Granger
  • Start date Start date
J

Jeff Granger

I'm using the TODAY function to put today's date on an invoice, however I
want to prevent the field updating if I open the worksheet in the future. Is
there any way of achieving this?

Jeff
 
Don't use a formula. To quickly add the current date just type

Ctrl + ;

The Today function along with Now and a number of other function are what is
refered to as volatile. Normal formula only recalculate when one of their
precedent cells is changed. Volatile function recaclulate every time a
calculation is run. That is why your date changes.
 
You must log in or register to reply here.

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

Date recalculates 1
Excel Excel Show Countdown Date 7
Auto date update 1
Recalculating when an Excel sheet gets the focus from outside Excel 10
Date Formatting 3
Excel Excel VBA Script help 0
Excel Message box with days of month & date. 1
Find Last Date Invoiced for Each Customer 3

Back
Top