Microsoft KB Archive/58053

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

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

= SUMMARY =

In a Works spreadsheet or database, use the following formula to calculate a person’s age

=Int((NOW- )/365.25)

where is the cell or field containing the person’s birthday. The 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.

&quot;Microsoft Works Reference Guide,&quot; version 2.0, page 298. &quot;Microsoft Works User's Guide,&quot; version 3.0, page 403. &quot;Microsoft Works User's Guide,&quot; version 4.0, page 581. =INT returns the largest integer less than or equal to the argument being calculated between the parenthesis.

&quot;Microsoft Works Reference Guide,&quot; version 2.0, page 292. &quot;Microsoft Works User's Guide,&quot; version 3.0, page 378. &quot;Microsoft Works User's Guide,&quot; 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.