How to enter Current Dates and Times in Excel?
To enter the current date and time in Excel, enter =NOW(),
To enter the current Date in excel, enter =TODAY().
The dates and/or times will be automatically updated when the sheet is updated or reopened.
To insert a fixed date, select a cell, and Press [Cntrl] + [;]
To add a fixed time, Press [Cntrl] + [Shift] +[;]