How to Get Current Date and Time in Excel

Last Updated on May 1, 2024 by Roshan Parihar

To get a current date on your Excel sheet, use Excel TODAY() for current date and NOW() for current time.

You can also use the keyboard shortcuts to find them with the examples given below. The keyboard shortcut is the fastest method to find your current dates and time. Let’s find out with the examples given below.

How to Get Current Date and Time in Excel Using NOW() Function

In order to get today’s daytime together in a cell. You have to use the NOW() as the method given in the below example.

Output

5/12/2019 12:40

The above example showing the daytime by using only one Function. This is the simple function which requires no argument to put in the function.

Print the Current Date Only Using Excel TODAY()

You can also print the current date using the Excel TODAY(). Use the below-given method to get your current date in the selected cell.

Output

5/12/2019

The above example showing the date in the output.

Both the above methods are useful to get today’s date in the selected cell. Choose your best method which you like most from the above-given methods.

Get Only Current Date in Excel Using Keyboard Shortcut

If you want to find the current date using the keyboard shortcut. First of all, go to the cell where you want to enter the date. Now, you have to just press the keyboard shortcut given below.

Keyboard Shortcut: ctrl + ;

The above shortcut prints the output in the selected cell of the Excel Sheet.

Print Only Current Time in MS Excel Sheet Using Keyboard Shortcut

You can also get the current time using the keyboard shortcut. Go to the cell where you have to print the current time. After that, just press the keyboard shortcut given below.

Keyboard Shortcut: ctrl + shift + ;

The above shortcut prints the time in AM or PM depends upon your current time. If you

You can print the current daytime together in the required cell. Use the above given two shortcuts for the current daytime. However, a function is also available in Excel which is given below to print the current date and time.

You may also like to read