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.
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 |
No comments:
Post a Comment