How to Get Current Date and Current Time in Excel

In this tutorial, learn how to get a current date on your Excel sheet. The short answer is to 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. The second method is the function method which requires to enter a function in Excel.

Get 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 the Current Date 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.

Find 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.

Print Daytime Using Excel 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.

You may also like to read