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(<date field or cell>,7),
"Saturday","Sunday","Monday","Tuesday",
"Wednesday","Thursday","Friday")
: 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.
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