Prevent Date Recalculating

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
 
G

Guest

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.
 

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
Date Formatting 3
Excel Excel VBA Script help 0
Date as a value to a textbox as a result from another textbox 1
date in excel 16
Complicated Date Calculation needed 5

Top