Excel has two useful functions for entering the current date, or the current date and time, automatically, TODAY and NOW.
To use the TODAY function:
Enter the formula =TODAY() in any blank cell. (The blank parentheses are necessary.) It returns the current date. If you open this spreadsheet tomorrow, it will list tomorrow’s date, that is, it will update each day.
To use the NOW function:
Enter the formula =NOW() in any blank cell. (Again, the blank parentheses are necessary.) It returns the current date and time.
Try it! Enter the TODAY and NOW functions in column B of the following spreadsheet. Then format result of NOW as time only—no date. After you’ve worked a few other exercises below, come back to this spreadsheet and see whether the time has changed. (You might have to force a recalculation to see the change. You can do this easily by pressing the F9 key.)
Dostları ilə paylaş: |
