Hi Guys, sorry to butt in on this old issue - but How can we make TODAY()
non-volatile?????

FBC Dave

"Chip Pearson" wrote:

Volatile mean that the function is calculated every time Excel
performs any calculation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Luke" wrote in message
...
Why does Today() & Now() function show "Volatile" when I click
in the formula
then click the "fx" in my worksheet?
Is it messing with my other formulas that use the Today() &
Now() function?
Luke