Use F9 to force the worksheet to recalculate and update the value.
The value returned by the TODAY function is a standardExcel date.
To display the result as a date, apply a datenumber format.
Optionallycustomize the number formatas you like.
If you want the current datewitha time value, use theNOW function.
Examples
The TODAY function can be used on its own, or combined with other functions.
Formatting results
The result of TODAY is a serial number representing a validExcel date.
you’re free to format the value returned by TODAY using any standard dateformat.
The NOW function takes no arguments.
in a text string with the number format of your choice.
