enter date of birth in a cell ( ex A1: 05/24/1980)
B1: =YEAR(TODAY())-YEAR(A1)

after that select cell B1 and go format cell - Number - General


pls do rate......

"brenner" wrote:

using todays date what formula do i use to calculate a person age using their
date of birth