Calculating Age in Excel 97

[Kirk]

Try this:

=ROUNDDOWN(((TODAY()-B2)/365),0)

Where B2 = the birthdate. Rounding down will take into
account that the birthday hasn't happened yet.

Hope this helps.

Kirk

 

[Leslie]

Kirk,

The value returned when I used this formula is 2/14/1900
0:00. Should I change the cell format on the birthdate
column?

Thanks!

 

[Chip Pearson]

Leslie,

Be sure format the cell as General or as a numeric format. You got
the result 2/14/1900 because dates are stored as the number of
days since 0-Jan-1900, 2/14/1900 is 45 days since 0-Jan-1900.
Therefore, if the actual age is 45, displaying it as a date
results in 2/14/1900.

Format the cell as General.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)