Microsoft KB Archive/111640

= Works: How to Display the Day of the Week =

Article ID: 111640

Article Last Modified on 11/15/2004

-

APPLIES TO


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

-



This article was previously published under Q111640



SUMMARY
There is no function or format option to display the day of the week. For example, there is no way to display "Saturday" for 1/1/94.

The following formula will display the day of the week in both the Spreadsheet and Database documents:

=CHOOSE(MOD( ,7),

"Saturday","Sunday","Monday","Tuesday",

"Wednesday","Thursday","Friday")

NOTE: The above formula should be typed as one line in a Spreadsheet cell or Database field, where refers to the field name or cell reference that contains the date or an actual serial number.



MORE INFORMATION
Because the Works Date Serial Number 1 represents Jan 1, 1900 (which is a Sunday), and the CHOOSE function index starts with option 0, the list of weekday names must start on Saturday.

Additional query words: 3.00 4.00 4.00a 4.50 4.50a w_works kbhowto 3 show weekday weekend word name d_works edit fill series

Keywords: kbhowto KB111640

-

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

© Microsoft Corporation. All rights reserved.