This doesn't account for leap years. For an older person you could easily be 20 days off.

--
Kind regards,

Niek Otten

"swatsp0p" wrote in message
...
|
| With the birthdate in cell A1, use this formula:
|
| =ROUNDDOWN((TODAY()-A1)/365,0)
|
| Format your cell as General with no decimal places to return the Age in
| full years.
|
| Does this work for you?
|
| Bruce
|
|
| --
| swatsp0p
|
|
| ------------------------------------------------------------------------
| swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
| View this thread: http://www.excelforum.com/showthread...hreadid=541683
|