Microsoft Office Tutorials and References
In Depth Information
Using Date Math
Figure 9.22.
Figure 9.22. After you apply the Date format, the answer is displayed cor-
After you apply the Date format, the answer is displayed cor-
rectly.
rectly.
In general, most formulas that refer to a date cell are automatically
formatted as a date. Most formulas that contain functions from the Date
category are formatted as a date (the WORKDAY function is one annoying ex-
ception). However, sometimes you do not want the result formatted as a date.
For example, in Figure 9.23 , you would like to count the number of days
between two dates. The formula in C4 should calculate 16 days. However, be-
cause Excel automatically formatted the result as a date, the answer of 16
is shown as 1/16/1900. In this case, you need to apply a numeric format to the
range containing the formula. When you select Number from the Number drop-
down on the Home tab, the formula appears with the correct result (see Fig-
ure 9.24 ) .
Search JabSto ::




Custom Search