TODAY function. Get the date(serial value) of the day.(Microsoft Excel)
Get the date(serial value) of the day.
This function is often used as an automatic entry for document creation dates, etc.
How it works
=TODAY()
Example Results
When a file is reopened or a cell (even a cell without a TODAY 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 to be fixed.
---