Article ID: 107189
Article Last Modified on 11/15/2004
APPLIES TO
- Microsoft Works 3.0 Standard Edition
- Microsoft Works 3.0a
- Microsoft Works 3.0b
- Microsoft Works 4.5 Standard Edition
- Microsoft Works 4.5a
- Microsoft Works 4.0 Standard Edition
- Microsoft Works 4.0a
This article was previously published under Q107189
SUMMARY
To add or subtract a certain number of years, months, and/or days to a date in a Works spreadsheet, use the following formula:
=Date(Year(ref)+years,Month(ref)+months,Day(ref)+days)
In the above formula, the years, months, and days are integers, and "ref" is a spreadsheet cell reference. If the formula returns an "ERR", the resulting date is probably out of the valid date range for Works, which is 1/1/1900 to 6/3/2079.
REFERENCES
For more information about how to perform this task in Works, see your
Works printed documentation or online Help.
"Microsoft Works for Windows User's Guide," version 3.0, Appendix A.
Additional query words: 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a kbhowto ss fmt formulas dates day w_works
Keywords: kbhowto kbinfo KB107189