Numbers: How do I convert a birth date to actual age?

Hello

Assuming that the birthday is in B1

=DATEDIF(B1,TODAY(),"Y")

will do the trick

Yvan KOENIG (from FRANCE lundi 10 décembre 2007 13:21:59)

Use the DATEDIF function

The Help in Numbers explains the syntax very well but do put in the quote marks when entering the method for the function.

For the "end date" part you could have a cell with the NOW() function in so it will update the result each time the sheet is opened. Use the Inspector to format the cells and turn off the Time element of NOW().

chris

Hello

Next time, it would be useful to describe your config.


When Numbers is used in English in a standard config, the decimal separator is period and the argument separator in formulas is comma.

You are using a "non-standard" config, which you may perfectly do, but nobody may guess that you are using Numbers in English on a system using the decimal comma (the reason why you must use the semi-colon).

May I add that to make the use of this config more confortable, you may download for FREE a script available on my iDisk:

<http://idisk.mac.com/koenigyvan-Public?view=web>

koenigyvan:Public: ForNumbers:pour_modifierNumbers.zip

Yvan KOENIG (from FRANCE lundi 10 décembre 2007 17:12:14)

As Yvan has implied, I think you are missing an "=" in front of the formula.