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
Figure 9.22 .
Search JabSto ::




Custom Search