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:
 
1. Create a new spreadsheet.
 
2. Format cells A1 and A2 as Number cells with the General format.
 
3. Type the date 12 April, 1992 in cell A1 and 13 May, 1992 in cell A2.
 
4. 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.