Age calculation on different END dates

[natalie2220]

I have a Birth date for individuals, but what to calculate the date they were in different years.

Eg 31/12/2008, 31/12/2009 etc. (31 December). the YEARFRAAC is not working, or I'm doing it wrong. any help how to formulate this?

[#2]

@natalie2220

What exactly is the problem?

Formula: =YEARFRAC(A2,B2)

I'm using point as decimal separator; if you use comma as decimal separator, the formula would be =YEARFRAC(A2;B2)

[#3]

@Hans Vogelaar 

here is how it come out my side. 

Births	Age @	31/12/2007	31/12/2008
07/03/1990		17/01/1900	00/01/1900

[#4 · Accepted solution]

@natalie2220 

Change the number format of the cells with the age formula to General.

[#5]

Thanks that worked!