Today not changing

[Daniel]

Hello.
I'm using the formula :
=TODAY()-30
The workbook remains open overnight.
When the date changes, there is no change in the cell value. I'll appreciate
some kind of automation (VBA OnTime ?).
Thanks in advance.
Daniel

 

[Arvi Laanemets]

Hi

Formulas in excel are recalculated whenever they are triggered. When there
are volatile functions used in formula, the formula is recalculated whenever
some cell entry is changed. Otherwise the formula is recalculated when some
of formula's parameters is changed.

TODAY is recalculated whenever something is changed in any cell.

Maybe you write a windows script, which closes and reopens your workbook
after midnight. Another option is to write an timer event for your workbook,
which recalculates the workbook at given time. But I'm not sure how this
will affect your workbooks performance - you have to use some cycle, because
there Excel misses built-in timer event.

 

[Bob Phillips]

Just hit the F9 key at the start of your working day.

--

HTH

RP
(remove nothere from the email address if mailing direct)