Works: How to Display the Day of the Week (111640)


The information in this article applies to:

  • Microsoft Works 3.0
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 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(<date field or cell>,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 <date field or cell> 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.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbhowto KB111640
©2004 Microsoft Corporation. All rights reserved.