Choose a cell where you want to show the current date and time and type NOW() and press the enter key then right-click on the cell and select format cells. select date and time and click ok to apply.

• This article describes the formula syntax and usage of the NOW function in Microsoft Excel.
• Find links to more information about working with dates and times in the See Also section.

The syntax for the NOW function in Excel is =NOW() Current date and time (varies)

The =NOW() will also display the current time.