Adding Date & Tiime
=> To insert the current date, press Ctrl+; (semi-colon).
=> To insert the current time, press Ctrl+Shift+; (semi-colon).
=> To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).
Change the date or time format
To change the date or time format, right-click on a cell, and select Format Cells. Then, on the Format Cells dialog box, in the Number tab, under Category, click Date or Time and in the Type list, select a type, and click OK.
Insert a date or time whose value is updated
A date or time that updates when the worksheet is recalculated or the workbook is opened is considered “dynamic” instead of static. In a worksheet, the most common way to return a dynamic date or time in a cell is by using a worksheet function.
To insert the current date or time so that it is updatable, use the TODAY and NOW functions, as shown in the following example. For more information about how to use these functions, see TODAY function and NOW function.
For example:
=TODAY() => Current date (varies)
=NOW() => Current date and time (varies)
No comments:
Post a Comment