Forum Discussion
Solved
Age calculation on different END dates
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?
Change the number format of the cells with the age formula to General.
4 Replies
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)
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 Change the number format of the cells with the age formula to General.
