ExcelBanter - Today() & Now() function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Today() & Now() function (https://www.excelbanter.com/excel-worksheet-functions/53790-today-now-function.html)

Luke

Today() & Now() function

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

Chip Pearson

Today() & Now() function

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

FBC Dave

Today() & Now() function

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

All times are GMT +1. The time now is 07:37 AM.