Kenzudxe

Shortcut Keys to Enter today's date and time To Enter Date First, you need to click the cell where you need to enter the date After that, press CTRL ;2In the Insert Date dialog, check the Using format option, and then double click a date formatting in the right pane See screenshot above Now current date is inserted into active cell with the specified date formatting Note By default current date is selected in the calendar in the Insert Date dialog boxIf you need to insert other date, you need to select the date in the calendar firstlyThis will hardcode today's date TODAY Function To create a formula that will calculate today's date, use the Excel Shortcuts Top Keyboard Shortcuts In Excel To Save Your Time Current date shortcut excel 2010