You can insert the current date or time into the main body of the document. The format of the inserted date and time is determined by the regional settings of your operating system.
Insert the current date
1.Select the cell or range of cells where you want to paste the date.
2.Use one of the following methods:
•On the Insert tab, click the Date button.
•Press the keyboard shortcut Ctrl+; (Cmd+;).
Insert the current time
1.Select the cell or range of cells where you want to insert the time.
2.Use one of the following methods:
•On the Insert tab, click the Time button.
•Press the keyboard shortcut Ctrl+Shift+; (Cmd+Shift+;).
If there is already data in the selected cell or range, it will be replaced.