Microsoft KB Archive/49728

Mac Works: Adding Days, Months, and Years to Dates in Worksheet

PSS ID Number: Q49728 Article last modified on 10-22-1998

2.0 3.0 4.0

MACINTOSH

================================================================ ==

The information in this article applies to:

 == Microsoft Works for the Macintosh, versions 2.0, 3.0, and 4.0 == 

= SUMMARY =

To add or subtract a certain number of years, months, and/or days to or from a date in a Microsoft Works Spreadsheet, use the following formula

=Date(Year + ,Month + ,Day + )

where is the cell that contains the date and is the number that you want to add to (or subtract from) your date.

For example, to find the date three years, one month, and five days from 1/1/89, where cell A1 contains the date, use the following formula:

=Date(Year(A1)+3,Month(A1)+1,Day(A1)+5)

Works will return the serial number 32178 for this equation. Format the cell as a Date and the cell will display the appropriate date.

In Works 2.0, choose Set Cell Attributes from the Format menu. In Works 3.0, choose Format Cells from the Format menu. In Works 4.0, choose Cell from the Format menu.

= Additional query words: 2.00 3.00 mwksss kbusage =

Version : 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.