update "=TODAY()" function

C

C.M.G.

I use the =TODAY() function in a spreadsheet which may stay open on the
desktop for several days. Unfortunately, the date does not seem to turn over
at midnight; I have to close and re-open the spreadsheet.

Is there a way to make the date turn over automatically, without closing and
re-opening?

Thanks,

Clem.
 
G

Gord Dibben

Shouldn't have to close and re-open.

Any simple recalculation will change the date to current one.

If you have calculation mode in Tools>Option set to Manual, you may not get a
recalc.

Investigate the use of ONTime VBA method to calc the workbook after midnight.

Chip Pearson explains the ONTime method here on his site.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP
 
C

C.M.G.

Thank you for your comments.

Clem.

Gord Dibben said:
Shouldn't have to close and re-open.

Any simple recalculation will change the date to current one.

If you have calculation mode in Tools>Option set to Manual, you may not
get a
recalc.

Investigate the use of ONTime VBA method to calc the workbook after
midnight.

Chip Pearson explains the ONTime method here on his site.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP
Click to expand...
 
Top