Use the Date & Time function or the NOW function to insert the date and time into your workbook. The date and time will be displayed at all times, but will only be updated when the worksheet is calculated. The NOW function looks like this:
To use the NOW Function:
Use the TODAY function to display only today's date in your worksheet. Use the TIME function to display only the time in your worksheet. |
|
The NOW function uses the computer's system clock to determine the date and time. |
|
You can also open the Insert Function box by:
|