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-