Works: Adding or Subtracting Days in Spreadsheet or Database

In Microsoft Works, the following formula can be used to add or subtract a certain number of years, months, and/or days to a date in a Database or Spreadsheet.

NOTE: In the formulas below, years, months, and days are integers, and "ref" is a spreadsheet cell reference or database field name. To simplify the formula for use with days only, use the following:

For example, if cell A1 contains the date 1/1/89, use the following formula to find the date 3 years, 1 month, and 5 days later: To find the date 60 days later, use the following formula: The result of each of these formulas is a serial number, for example, 33640 for the first formula. To show it as a date, select the cell or field containing the formula, and format it in the desired date format.

For more information about this topic, see your Works printed documentation or online help.