Works: How to Display the Day of the Week

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q111640

Expand all | Collapse all

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.

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

Back to the top

kbhowto KB111640

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top