Tip Printed from ExcelTip.com
Entering the Current Date into a Cell


Using keyboard shortcuts

To enter the current date in a cell:

Select a cell and press Ctrl+;.
The formula that calculates the current date is:
=TODAY ()