Mac Works 4.0: How to Sort by Month or Day in a Spreadsheet
  
PSS ID Number: Q150745
Article last modified on 10-22-1998
 
4.0
 
MACINTOSH
 

======================================================================
----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 4.0, 4.0a, 4.0b
----------------------------------------------------------------------
 
SUMMARY
=======
 
This article describes how to sort dates by month in a spreadsheet when the
cells are formatted with the Date function.
 
MORE INFORMATION
================
 
When dates listed in a spreadsheet column are sorted, the information will
sort in ascending or descending order based on the year. If no year
exists, the program will assume the current year.
 
To Sort a List of Dates by Month
--------------------------------
 
If you prefer to have your dates sorted by month, do the following:
 
1. In an adjacent column, enter the following formula:
 
      =MONTH(A1)
 
2. Fill this formula down to reference all your dates, for example:
 
    Row#       Column A             Column B       Formula in Column B
      1        March 3, 1966          3               =MONTH(A1)
      2        April 23, 1952         4               =MONTH(A2)
      3        January 2, 1990        1               =MONTH(A3)
      4        January 4, 1935        1               =MONTH(A4)
 
3. Highlight A1 through B4 and sort on column B.
 
All your dates will be sorted by month.
 
For added information, refer to the Microsoft Works 4.0 User's Guide
Chapter 11, "Guide to Spreadsheet and Database Functions", page 580.
 
Additional query words: 4.00 mac m_works
======================================================================
Version           : 4.0
Platform          : MACINTOSH
Issue type        : kbhowto
=============================================================================
Copyright Microsoft Corporation 1998.