Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |