Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Chinese - Traditional	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Czech	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Danish	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Dutch	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Compliant*
Language: English	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	04 Oct 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations:   Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Compliant*
Language: English Australian	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	06 Oct 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations:   Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at www.microsoft.com/works/ Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Compliant*
Language: English British	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	06 Oct 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations:   Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at www.microsoft.com/works/ Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Finnish	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Compliant*
Language: French	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	04 Oct 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations:   Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Compliant*
Language: German	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	04 Oct 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations:   Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Hungarian	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Compliant*
Language: Italian	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	04 Oct 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations:   Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Japanese	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Korean	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Norwegian	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Polish	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Portuguese (Brazil)	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Portuguese	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Russian	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Spanish	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 3.0	Category:Not Compliant
Language: Swedish	OS: 16-Bit Win	Release Date: 29 Oct 1993
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	None
Product Dependencies:	DOS and Windows 3.1
Clock Dependencies:	System clock
Last Updated:	22 Sep 1999
Product Details
This Product Guide pertains to Works for Windows only: Recommendations: Microsoft recommends using 4-digit year entry in cells. No fix will be delivered for Works 3.0 or earlier. Description of how the product handles dates:        Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works versions 3.0, 4.0x and 4.5 assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors:        The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works Ver 3.0, 4.0x and Ver 4.5 assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010––unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0	Category:Not Compliant
Language: Chinese - Traditional	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	NONE
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	11 Oct 1999
Product Details
Description of how the product handles dates:   ·         Storage.  Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900.  In addition, Works stores 4-digit years in files, even when entry uses only 2 digits.   ·         Parsing on date entry.   If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value.    ·         Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000.   ·         Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after.   2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.     Common date usage errors:   ·         The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. ·         4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value.  ·         Editing Existing cells with a visual format that displays 2 digits for the year.  If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. ·         Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution:   To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format.  This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0	Category:Not Compliant
Language: Korean	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	NONE
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	11 Oct 1999
Product Details
Description of how the product handles dates:   ·         Storage.  Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900.  In addition, Works stores 4-digit years in files, even when entry uses only 2 digits.   ·         Parsing on date entry.   If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value.    ·         Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000.   ·         Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after.   2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.     Common date usage errors:   ·         The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. ·         4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value.  ·         Editing Existing cells with a visual format that displays 2 digits for the year.  If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. ·         Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution:   To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format.  This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Canadian French	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/. See below for download.
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
Recommendations to meet compliance: A fix for the Year 2000 issues identified below for Works for Windows 4.0 and 4.5 (English versions only) is available from Microsoft Technical Support's web site at http://support.microsoft.com/support/kb/articles/q191/9/99.asp or directly from the Works product web site at http://www.microsoft.com/works/. Fixes for all other languages, except Korean and Traditional Chinese, will follow in the 1st and 2nd quarters of 1999 and will be available from your local Technical Support. Microsoft recommends using 4-digit year entry in cells until the fix is available. No fix will be delivered for Works 3.0 or earlier.   Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Czech	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to contact Microsoft Product Support for assistance. To get more information on contacting product support, click Programs, drag to choose Microsoft Works, and then drag to choose Microsoft Works Product Support.
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
Prerequisites The user needs to contact Microsoft Product Support for assistance. To get more information on contacting product support, click Programs, drag to choose Microsoft Works, and then drag to choose Microsoft Works Product Support. Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Danish	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Dutch	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: English	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites for compliance? The user needs to install the Year 2000 update for Microsoft Works. The update is available from Microsoft Technical Support's web site at http://support.microsoft.com/support/kb/articles/q191/9/99.asp or directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: English Australian	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites for compliance? The user needs to install the Year 2000 update for Microsoft Works. The update is available from Microsoft Technical Support's web site at http://support.microsoft.com/support/kb/articles/q191/9/99.asp or directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: English British	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites for compliance? The user needs to install the Year 2000 update for Microsoft Works. The update is available from Microsoft Technical Support's web site at http://support.microsoft.com/support/kb/articles/q191/9/99.asp or directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired. Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Finnish	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Patch
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: French	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: German	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Hungarian	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to contact Microsoft Product Support for assistance. To get more information on contacting product support, click Programs, drag to choose Microsoft Works, and then drag to choose Microsoft Works Product Support.
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
Prerequisites   The user needs to contact Microsoft Product Support for assistance. To get more information on contacting product support, click Programs, drag to choose Microsoft Works, and then drag to choose Microsoft Works Product Support. Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Italian	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Japanese	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	See below
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
Recommendations to meet compliance: A fix for the Year 2000 issues identified below for Japanese Works for Windows 4.0 is available from the Japanese Works product web site at http://www.microsoft.com/japan/home/works/download/wks40sr.htm. Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Norwegian	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Polish	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Patch
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Portuguese (Brazil)	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to contact Microsoft Product Support for assistance. To get more information on contacting product support, click Programs, drag to choose Microsoft Works, and then drag to choose Microsoft Works Product Support.
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
Prerequisites The user needs to contact Microsoft Product Support for assistance. To get more information on contacting product support, click Programs, drag to choose Microsoft Works, and then drag to choose Microsoft Works Product Support. Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Portuguese	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	The user needs to contact Microsoft Product Support for assistance. To get more information on contacting product support, click Programs, drag to choose Microsoft Works, and then drag to choose Microsoft Works Product Support.
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
Prerequisites The user needs to contact Microsoft Product Support for assistance. To get more information on contacting product support, click Programs, drag to choose Microsoft Works, and then drag to choose Microsoft Works Product Support. Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Russian	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Works Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Works	Version: 4.0, 4.0a	Category:Compliant*
Language: Spanish	OS: 32-Bit Win	Release Date: 24 Aug 1995
Operational Range:	01 Jan 1900 - 03 Jun 2079
Prerequisites:	Microsoft Year 2000 Update
Product Dependencies:	Works 4.0: Windows 95 or Windows NT 3.51
Clock Dependencies:	System clock
Last Updated:	19 Oct 1999
Product Details
What are the prerequisites? The user needs to install the Year 2000 update for Microsoft Works. The update is available directly from the Works product web site at http://www.microsoft.com/works/ Description of how the product handles dates: Storage. Microsoft Works stores all dates in a serialized fashion starting with January 1, 1900, and continuing to June 3, 2079, or, stated another way, by numeric value from 1 through 65534. For example, if the date 1/1/1900 is entered, Works stores it internally with a value of 1. If the date 6/1/1998 is entered, Works stores it internally with a value of 35947, since this is the number of days since the starting point of 1/1/1900. In addition, Works stores 4-digit years in files, even when entry uses only 2 digits. Parsing on date entry. If a date is entered with a 2-digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx. If the user wants to enter a date that occurs in the year 2000 or later, the user must enter the 4-digit year value. Once the 4-digit year value has been entered, the date can be visually formatted to show only 2 digits for the year value. Works sorts on full years (4-digit dates) even if only 2 digits are displayed. Also, Works sorts dates when some are prior to 2000 and some are after 2000. Although Works does not utilize a date format, which incorporates day of the week, it executes leap years and displays 2/29 in appropriate years, including the year 2000 and after. 2-digit shortcut handling: Works handles all short date years as 19xx. That is, since all dates are converted and stored as a serial value representing the number of days since 1/1/1900, the visual formatting applied to the date has no affect on the actual value of the date itself. However, when initially entering data, if only 2 digits are entered for the year value, Works assumes that the year is 19xx. To enter a date that occurs in the year 2000 or beyond, the date must be entered with its 4-digit year value and the visual formatting changed as desired.   Common date usage errors: The DATE() function is not designed to take 2-digit year shortcuts, since it receives numeric parameters. The DATE() function calculates a number less than 1900 as an offset from 1900. So, if you were to enter a formula such as =DATE(15,1,1), the resulting date would be January 1, 1915, not 2015. 4 digit year entry required to enter a date that occurs in year 2000 or later (i.e., if a date is entered with a 2 digit year (i.e. 6/1/98), Works assumes that the century for the year is 19xx). If the user wants to enter a date that occurs in the year 2000 or later, it must be entered with a 4-digit year value. Once it has been entered, it can be visually formatted to show only 2 digits for the year value. Editing Existing cells with a visual format that displays 2 digits for the year. If a date is entered and formatted as a 4-digit year date and the year is 2000 or above, and subsequent to that the cell where the date is entered is reformatted to a 2-digit year format, the Year 2000 formatting will be lost if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show only 2 digits for the year (6/1/10), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a 2-year format, Works again assumes that the year occurs in the century 19xx. Editing Existing cells with a visual format that displays no digits for the year. If a date is entered and formatted to a format which does not display a year component, the value of the year component will be changed to the current year if the cell in which the date is located is edited. For example, if the date is entered as 6/1/2010 and the formatting is changed to show no digits for the year (6/1), the internal representation of the date is still 6/1/2010 – unless the cell is edited. If the cell is edited after the date format has been changed to a no-year format, Works assumes that the year is the current year, based on the system clock. Solution: To avoid any misunderstanding by the user, dates should be entered and displayed in a 4-digit format. This will ensure the correct century is being used, and the date will not converted to an unexpected century during editing.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.