NOW
What Does It Do?This function shows the current date and time. The result will be updated each time the
worksheet is opened and every time an entry is made anywhere on the worksheet.
worksheet is opened and every time an entry is made anywhere on the worksheet.
Syntax
=NOW()
=NOW()
Formatting
The result will be shown as a date and time. If it is formatted to show as a number
the integer part is used for the date and the decimal portion represent the time.
The result will be shown as a date and time. If it is formatted to show as a number
the integer part is used for the date and the decimal portion represent the time.