How to Display the Current Date in a Cell in Microsoft Excel ?

Microsoft Excel 2016 provides the functions =TODAY() and =NOW() which displays the current date in a cell in Excel sheet.

How to Display the Current Date in a Cell in Microsoft Excel ?

Both of the functions would display the current date and this date will be automatically change or recalculated when the Worksheet is opened.

The =NOW() will also display the time.

image

Alternatively , you can use the shortcut key Ctrl + ; to display the current date.

Leave a Reply