Microsoft KB Archive/61783

= Works: Formula to Add Days to a Date in the Spreadsheet =

Article ID: 61783

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 3.0 for MS-DOS
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition

-



This article was previously published under Q61783



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)



MORE INFORMATION
In the above formula, &quot;years,&quot; &quot;months,&quot; and &quot;days&quot; are integers and &quot;(ref)&quot; is a spreadsheet cell reference.

For example, if cell A1 contains the date 1/1/89, use the following formula to find the date three years, one month, and five days later.   =Date(Year(A1)+3,Month(A1)+1,Day(A1)+5) The result of this formula is the serial number 33640. It displays as &quot;February 6, 1992&quot; when Cell Attributes in the Format menu is set to display Date Long.

NOTE: The above procedure is a correction to the steps in the &quot;One-to- One with Microsoft&quot; publication, Issue 10, Page 7.

Additional query words: database function

Keywords: KB61783

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.