Microsoft KB Archive/150761

Mac Works 4.0: How to Get Numerical Results from Date Cells

PSS ID Number: Q150761 Article last modified on 10-22-1998

4.0 4.0a 4.0b

MACINTOSH

================================================================ ==

The information in this article applies to:

 == Microsoft Works for the Macintosh, versions 4.0, 4.0a, 4.0b, and 4.0c == 

= SUMMARY =

This article describes how to obtain number results from cells formatted with the Date format.

= MORE INFORMATION =

If a cell contains a date formula and is formatted with the Date format, results from the cell appear as a date instead of a number. For an example of how to obtain numerical results, follow these steps:

  Create a new spreadsheet.   Format cells A1 and A2 as Number cells with the General format.   Type the date 12 April, 1992 in cell A1 and 13 May, 1992 in cell A2.   To subtract 12 April, 1992 from 13 May, 1992, type either of the following formulas in cell B1: =Date(1992,5,13)-Date(1992,4,12) -or- =A2-A1 When you press ENTER, the value 31 should appear in cell B1, meaning that 31 days have occurred between these two dates. 

Notes:


 * You receive a negative number if you subtract the later date from the earlier date. This occurs because each date corresponds to a serial number equivalent ranging from 0 to 49710 (with 0 representing January 1, 1904 and 49710 representing February 6, 2040). If you subtract a later date from an earlier date, you are subtracting a higher number from a lower number, resulting in a negative number.
 * The dates must be in the range from January 1, 1904, to February 6, 2040 (serial number equivalents 0 to 49710). Works does not recognize any date outside of this range. The year should be a value in the range from 1904 to 2040, the month should be a value in the range from 1 to 12, and the day should be a value in the range from 1 to 31.

= REFERENCES =

For additional information about date and time functions, refer to the Works 4.0 “User’s Guide,” Chapter 11, “Guide to Spreadsheet and Database Functions,” page 579.

= Additional query words: 4.00 4.00a 4.00b mac m_works mwksss =

Version : 4.0 4.0a 4.0b Platform : MACINTOSH Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.