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
 
J

Jim Thomlinson

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.
 
Top