Today() & Now() function

L

Luke

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
 
C

Chip Pearson

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
 
F

FBC Dave

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

FBC Dave
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
Visio Utilizing 100% Memory - Troubleshooting 0
Today() function 2
Show value from one cell in another cell if today falls between a date range 5
Office 2010, background images do not appear in print preview nor print 0
Excel - Wich Function should I use? 1
Yield to Maturity 10
How to make scroll bar permanently visible, Word 365 0

Top