Microsoft KB Archive/80646

= Works: Date Formulas Error in Documentation =

Article ID: 80646

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a

-



This article was previously published under Q80646



SUMMARY
In the &quot;Microsoft Works for Windows User's Guide,&quot; there is an error on page 376 of Appendix A, &quot;Spreadsheet and Database Functions.&quot; The date formula example is incorrect because it uses double quotation marks instead of single quotation marks:

INCORRECT: =&quot;3/29/89&quot;-&quot;10/30/60&quot;

CORRECT: ='3/29/89'-'10/30/60'



MORE INFORMATION
If you type a date formula with double quotation marks, as in the incorrect example above, you will get the following error message:

Reference not valid or wrong operand type.

Choose the OK button and correct the formula to continue.

As an alternative to the date formula, the DATE function can be used:

=DATE(89,3,29)-DATE(60,10,30)

