Search This Blog

Saturday, 3 December 2016

How to enter Current Dates and Times in Excel?

To enter the current date and time , select a cell and in the cell enter =NOW()
To enter the current Date in excel, select a cell and in the cellr =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 [Ctrl] + [;]
To add a fixed time, Press [Ctrl] + [Shift] +[;]


For above 2 the dates and/or times will NOT be automatically updated when the sheet is updated or reopened.


Excel Dates Tips
Excel Dates




No comments:

Post a Comment