How to Enter Date in Excel: Quick and Easy Tips

Insert a static date or time into an Excel cell To insert the current date, press Ctrl+, (semi-colon). To insert the current time, press. + , (semi-colon). To insert the current date and time, press Ctrl+, (semi-colon), then press Space, and then press. + , (semi-colon).

Entering date and time in Excel spreadsheets can be a time-consuming process, but it doesn’t have to be. In this short Excel tutorial, we’ll show you a couple of tips to quickly enter today’s date and time into your spreadsheets.

Firstly, we’ll look at how to enter today’s date with a simple formula. All you need to do is use the formula “=today()” and every time you open the spreadsheet, it will display the current date. However, sometimes you might not want the date to change every time you open the spreadsheet. For instance, if you have a list of employees and their hire date, you wouldn’t want the hire date to change every time you open it up. In this case, you can use the shortcut of typing the month forward slash and then the day, leaving the year off, and tapping enter on the keyboard.

But, we have an even faster way to do this. Simply click on a particular cell, hold the ctrl key and then tap semicolon. This will automatically put whatever today’s date is right into that cell that is selected. Then, tap enter on the keyboard and you’re ready to move on.

What if the time that Jennifer was hired was also important? All you have to do is hold ctrl, hold shift, and then tap semicolon and it puts in the current time. It’s important to note that these dates and times do not update or change unless you click on them and type over them.

These tips on how to enter date and time in Excel can save you a lot of time and effort. If you found this tutorial helpful, please consider connecting with us on social media and subscribing to our YouTube channel for more videos about technology for teachers and students.


How do I enter a date in an Excel formula?
Type a date in Cell A1 and in cell B1, type the formula =EDATE(4/15/2013,-5). Here, we're specifying the value of the start date entering a date enclosed in quotation marks. You can also just refer to a cell that contains a date value or by using the formula =EDATE(A1,-5)for the same result.
How do I automatically create a date in Excel?
Select a spreadsheet cell and enter a date using the mm/dd/yyyy format. ... Go to the Home tab and choose the Fill option from the Editing section.Click the Series option from the drop-down menu.Choose a date unit from the list.Click on OK.
How do I insert a date into text in Excel?
Select the cell where you want the combined data.Type the formula, with text inside double quotes, and the date inside the TEXT function. For example, to show the full weekday name, for the current date: ="Today is " &, TEXT(TODAY(),"dddd")Press Enter to complete the formula.