This tutorial demonstrates various ways of entering dates in Excel. See how to insert today's date and current time as static time stamp or dynamic values, how to auto populate a column or row with weekdays, and how to auto fill random dates in Excel. There are several ways to add dates in Excel depending on what exactly you want to do. For example, do you want to enter a today's date in some report or invoice? Or, perhaps you want to insert a date in Excel that will update automatically and always display the current date and time?
Microsoft Excel has a function that updates the date automatically whenever the spreadsheet is opened. So every time you access the spreadsheet, you can just print out the sheet and it will have the current date on it. This feature allows you to keep track of different modifications of the spreadsheet in paper form without having to remember to note down or change the date yourself. Press "Enter" on your keyboard. The day will automatically appear and update.
You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command. Select the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential dates. Fill handles can be dragged up, down, or across a spreadsheet. Select the cell with the first date.
Microsoft Excel is preprogrammed to make it easier to enter dates. This is very frustrating when you enter something that you don't want changed to a date. Unfortunately there is no way to turn this off.