NOW function. Get the current date and time (serial value).(Microsoft Excel)
Get the current date and time (serial value).
This function is often used as an automatic entry for document creation time, etc.
How it works
=Now()
Example Results
When a file is reopened or a cell (even a cell without a NOW function) is recalculated, the result changes.
Therefore, when the date is actually entered, it must be converted to a fixed value by pasting a value in order for the date and time to be fixed.
---