Microsoft Office Tutorials and References

In Depth Information

**Using Date Math**

important to recognize that dates in 2013
–
2016 fall in the range of 41,275 to

42,735. So, if you are expecting a date answer as the result of a formula and

get a number in this range, the answer probably needs to have a date format

applied.

Figure 9.21.

Figure 9.21.
The formula appears to give the wrong answer. However, this is

The formula appears to give the wrong answer. However, this is

a formatting problem.

a formatting problem.

To apply a date format, on the Home tab use the Number drop-down to choose

the Date format. The answer in column D now appears correctly, as shown in