Works: How to Add or Subtract Days to or from a Date in a Spreadsheet Cell

This article describes how to add or subtract a specified number of years, months, or days to or from a date in a Works spreadsheet cell.

To add or subtract a specified number of years, months, or days to or from a date in a Works spreadsheet cell, use the following formula: where years, months, and days are integers, and cellref is a spreadsheet cell reference.

As an example, to find the date that is three years, one month, and five days later than the date stored in cell A1, use the following formula: If cell A1 contains the date "1/1/1989," the formula returns the serial number "33640." This serial number is displayed as "February 6, 1992" when you assign the Time/Date format to the cell that contains the formula.

To assign the Time/Date format to a cell:

1. Click the cell you want to format.
2. On the Format menu, click Number.
3. In the Format box, click Date.
4. In the Date Options box, select the date format that you prefer.
5. Click OK.

If the formula returns a string of POUND SIGNS (#), the column is too narrow to display the calculated date. Increase the width of the column.

If the formula returns an "ERR" string, the calculated date probably falls outside of the valid date range for Works. The valid date range for Works is from 1/1/1900 to 6/3/2079.