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