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.
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.
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.
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.
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
- Autofill Dates, Months And Current Time In Excel Sheet
- Copy Data In Alternate Rows Selected In Excel
- How To Quickly Select All Cells Of A Column In Excel
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.