Microsoft KB Archive/109046

= Works: Result of the Month Function Displays as "January" =

Article ID: 109046

Article Last Modified on 11/24/2003

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.0 Standard Edition

-



This article was previously published under Q109046



SUMMARY
The Month function in Works can be used to extract the month number from a date. However, if the field or cell that contains this result is formatted as Month Only for the Date format, the result will always display as "January".



RESOLUTION
Format the cell containing the result as General. In Works 3.0, 4.0, 4.5, or 4.5a, choose Number from the Format menu and choose General. In Works 2.x, choose General from the Format menu.

-or-

You can multiply the number Month returns by 29. This will always display the correct month.



MORE INFORMATION
The Month function returns a number, 1 for January, 2 for February, and so on. Because Works sees dates as a serial number representing the number of days since January 1, 1900, the numbers 1-12 will always be the first 12 days of January if the cell is formatted as a date.

Additional query words: swept_45a_Upd: rickvi

Keywords: KB109046

-

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

© Microsoft Corporation. All rights reserved.