Date that changes
 

How do I get =NOW{} in a cell that show a date that changes whenever I open
a sheet? It worked before. What am I now missing? I seem to get a number
in the cell.

Date that changes
 

Format the cell as a date.

"BertP" wrote in message
...
How do I get =NOW{} in a cell that show a date that changes whenever I
open a sheet? It worked before. What am I now missing? I seem to get a
number in the cell.

Date that changes
 

BertP,

Are you using "=NOW{}" (curly braces) or "=NOW()" (parentheses)? The
correct way is with parentheses.

Also, "=NOW()" returns the current date and time. Every time your worksheet
recalculates, it will update the cell value to the current date and time.
If you have your cell formatted as a date-only format, you won't notice the
value change. But if you have other calculations that depend on this cell,
you might notice a slight change in the values each time it recalculates.

If you use "=TODAY()" instead (TODAY() is just the current date....time not
included), then the value of the formula only changes when the date changes.
If you have calculations based on this cell, the values won't change each
time it recalcs.......they will only change when the date changes.

HTH,

Conan




"BertP" wrote in message
...
How do I get =NOW{} in a cell that show a date that changes whenever I
open a sheet? It worked before. What am I now missing? I seem to get a
number in the cell.