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

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021