How to Get Current Date and Current Time in Excel

In this tutorial, learn how to get a current date on your Excel sheet. You can also find the current time using the methods given below. Use the keyboard shortcut and the Excel functions to find the current day time.

The keyboard shortcut is the fastest method to find your dates and time. The second method is the function method which requires to enter a function in Excel.

How to Get Current Date in Excel

If you want to get 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.

Use Excel TODAY() to Print the Current Date

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 Current Time in MS Excel Sheet

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.

Use Excel Function For Current Daytime

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

Hope, you like this post of how to print today’s day time in the cell of Excel Sheet. If you have any query regarding the tutorial, please comment below.

Also tell me, what other methods you are using to find today’s day time by commenting below.

Leave a comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.