Mac Works: Formula to Calculate Age in Spreadsheet
PSS ID Number: Q58053 Article last modified on 10-22-1998
2.0 3.0 4.0
MACINTOSH
==========================================================
| The information in this article applies to: |
| - Microsoft Works for the Macintosh, versions 2.0, 3.0, and 4.0 |
SUMMARY
In a Works spreadsheet or database, use the following formula to calculate a person’s age
=Int((NOW()-<bday>)/365.25)
where <bday> is the cell or field containing the person’s birthday. The <bday> cell or field must be formatted as a date.
MORE INFORMATION
The following are brief definitions for each of the functions used in this article:
=NOW() generates the current date as displayed by the computer’s internal clock; this is usually the current date and time.
"Microsoft Works Reference Guide," version 2.0, page 298.
"Microsoft Works User's Guide," version 3.0, page 403.
"Microsoft Works User's Guide," version 4.0, page 581.
=INT() returns the largest integer less than or equal to the argument being calculated between the parenthesis.
"Microsoft Works Reference Guide," version 2.0, page 292.
"Microsoft Works User's Guide," version 3.0, page 378.
"Microsoft Works User's Guide," version 4.0, page 558.
KBCategory: kbusage KBSubcategory: macworkskb
Additional reference words: 2.00 3.00 how old number of years mwksdb mwksss
Version : 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.
