Microsoft KB Archive/150745

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:

  In an adjacent column, enter the following formula: =MONTH(A1)   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)   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.