Microsoft Office Tutorials and References
In Depth Information
Displaying a System Date
To Enter the Projected Monthly Sales
The following steps enter the projected monthly sales, listed earlier in Table 3–1 on
page EX 167, in row 4 and compute the projected semiannual sales in cell H4.
1 If necessary, click the Home tab on the Ribbon.
2 Enter 3383909.82 in cell B4, 6880576.15 in cell C4, 9742702.37 in cell D4, 4818493.53
in cell E4, 4566722.63 in cell F4, and 8527504.39 in cell G4.
3 Click cell H4 and then click the Sum button on the Ribbon twice to total the semiannual
sales in cell H4 (Figure 3–20).
Your Age in Days
How many days have you
been alive? Enter today’s
date (e.g., 12/5/2008) in
cell A1. Next, enter your
birth date (e.g., 6/22/1986)
in cell A2. Select cell A3
and enter the formula
=A1 - A2. Format cell A3
to the General style using
the Number Dialog Box
Launcher. Cell A3 will
display your age in days.
columns B, C, and
D not displayed
when active cell
is in column H
sales for last three
row titles frozen
Updating the System
Date and Time
If the system date and
time appear in an active
worksheet, Excel will
not update the date and
time in the cell until you
enter data in another cell
or complete some other
activity, such as undoing
a previous activity or
pressing function key F9.
The sketch of the worksheet in Figure 3–3a on page EX 166 includes a date stamp on
the right side of the heading section. A date stamp shows the date a workbook, report,
or other document was created or the period it represents. In business, a report often
is meaningless without a date stamp. For example, if a printout of the worksheet in this
chapter were distributed to the company’s analysts, the date stamp would show when the
six-month projections were made, as well as what period the report represents.
A simple way to create a date stamp is to use the NOW function to enter the system
date tracked by your computer in a cell in the worksheet. The NOW function is one of
14 date and time functions available in Excel. When assigned to a cell, the NOW function
returns a number that corresponds to the system date and time beginning with December 31,
1899. For example, January 1, 1900 equals 1, January 2, 1900 equals 2, and so on. Noon
equals .5. Thus, noon on January 1, 1900 equals 1.5 and 6 P.M. on January 1, 1900 equals
1.75. If the computer’s system date is set to the current date, which normally it is, then the
date stamp is equivalent to the current date.
Excel automatically formats this number as a date, using the date and time format,
mm/dd/yyyy hh:mm, where the ﬁ rst mm is the month, dd is the day of the month, yyyy is
the year, hh is the hour of the day, and mm is the minutes past the hour.