The TODAY() function will give you the current date, well the date set on your computer. By using this you can calculate someone’s age although this can be used for anything were you want to know how old it is or how long it will take.
Also check out the tutorial on calculating the number of days between dates.
Watch this video to see how to calculate someone’s age
Gary Schwartz's Blog 