[Solved] Error using formulas to calculate the age

[x-x51h]

Hi. I'm trying different formulas to calculate the age of a person but I always get an error. Or 501 or 508.
Thanks.

[robleyd]

It would help if you tell us exactly what formulas you are trying and what error you get with each; or better upload a sample spreadsheet showing the problems you are encountering.

[Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire. The link also contains information on how to anonymise your document if it contains confidential information.

[x-x51h]

=DATEDIF(A2,NOW(),"y") - Err:501

=DATEDIF(A2,TODAY(),"Y") & " Years, " & DATEDIF(A2,TODAY(),"YM") & " Months, " & DATEDIF(A2,TODAY(),"MD") & " Days" - Err:501

With other formulas that I don't remember now, the error was 508.

[robleyd]

Calc does not have a DATEDIFF function - that is a Base function.

See Calculate a persons age from birthdate for some ideas.

[x-x51h]

=YEARS(DATE(A1;1;1); TODAY(); 0)
This formula works with no errors.
Thanks a lot!