Microsoft KB Archive/239158

= Works 2000: Year Function Does Not Return Accurate Date =

Article ID: 239158

Article Last Modified on 7/4/2007

-

APPLIES TO


 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2000
 * 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 Q239158



SYMPTOMS
If you use the year function in a formula that is designed to calculate the year 2000 in Microsoft Works Spreadsheet, the year may be calculated incorrectly.



CAUSE
This problem may occur if the following conditions are true:
 * The date entered in the date cell is later than 12/31/1999.
 * The cell in which you want to calculate the year is formatted as a date.



RESOLUTION
To work around this problem, use one of the following methods.

Calculate a 4-Digit Year
To calculate a 4-digit year:  In Works Spreadsheet, click the cell in which you want the year to be calculated. On the Format menu, click Number. Under Format, click the General option, and then click OK.

Note Do not click the Date option. If you do, the formula cannot calculate the year properly. Type the following formula in the cell

=year+1900

where  is the date cell from which the preceding formula derives the year.

Calculate a 2-Digit Year
To calculate a 2-digit year:  In Works Spreadsheet, click the cell in which you want the year to be calculated.</li> On the Format menu, click Number.</li> Under Format, click the Leading Zeros option.</li> In the Number of digits box, type 2, and then click OK.

Note Do not click the Date option. If you do, the formula cannot calculate the year properly.</li> Type the following formula in the cell

=year-100

where  is the date cell from which the preceding formula derives the year.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="moreinformation_section">

MORE INFORMATION
If you run Microsoft Works 4.x without having installed the Y2K patch, the year may be calculated as 0. If this is the case, download and install the Works 4.x Y2K patch from the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=32E7205A-3880-4416-9260-57A96C8A9A76

Note This patch does not fix the issue listed in the "Resolution" section of this article, but it does allow Works Spreadsheet to recognize dates in the year 2000 and later.

Additional query words: 4.00 4.50 w_works works2k year2000 year2k

Keywords: kbbug kbdisplay kbpending kbui KB239158

-

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

© Microsoft Corporation. All rights reserved.