SOLVED

Age calculation on different END dates

%3CLINGO-SUB%20id%3D%22lingo-sub-3357046%22%20slang%3D%22en-US%22%3EAge%20calculation%20on%20different%20END%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357046%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Birth%20date%20for%20individuals%2C%20but%20what%20to%20calculate%20the%20date%20they%20were%20in%20different%20years.%3C%2FP%3E%3CP%3EEg%2031%2F12%2F2008%2C%2031%2F12%2F2009%20etc.%20(31%20December).%20the%20YEARFRAAC%20is%20not%20working%2C%20or%20I'm%20doing%20it%20wrong.%20any%20help%20how%20to%20formulate%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3357046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3357168%22%20slang%3D%22en-US%22%3ERe%3A%20Age%20calculation%20on%20different%20END%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357168%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386972%22%20target%3D%22_blank%22%3E%40natalie2220%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EWhat%20exactly%20is%20the%20problem%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1422.png%22%20style%3D%22width%3A%20369px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370769i9454FFD6786CEA9B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1422.png%22%20alt%3D%22S1422.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EFormula%3A%20%3DYEARFRAC(A2%2CB2)%3C%2FP%3E%0A%3CP%3EI'm%20using%20point%20as%20decimal%20separator%3B%20if%20you%20use%20comma%20as%20decimal%20separator%2C%20the%20formula%20would%20be%20%3DYEARFRAC(A2%3BB2)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3357354%22%20slang%3D%22en-US%22%3ERe%3A%20Age%20calculation%20on%20different%20END%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehere%20is%20how%20it%20come%20out%20my%20side.%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22311%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2278%22%3EBirths%3C%2FTD%3E%3CTD%20width%3D%2251%22%3EAge%20%40%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E31%2F12%2F2007%3C%2FTD%3E%3CTD%20width%3D%2291%22%3E31%2F12%2F2008%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E07%2F03%2F1990%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E17%2F01%2F1900%3C%2FTD%3E%3CTD%3E00%2F01%2F1900%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3358499%22%20slang%3D%22en-US%22%3ERe%3A%20Age%20calculation%20on%20different%20END%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3358499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386972%22%20target%3D%22_blank%22%3E%40natalie2220%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20the%20number%20format%20of%20the%20cells%20with%20the%20age%20formula%20to%20General.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362531%22%20slang%3D%22en-US%22%3ERe%3A%20Age%20calculation%20on%20different%20END%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362531%22%20slang%3D%22en-US%22%3EThanks%20that%20worked!%3C%2FLINGO-BODY%3E
New Contributor

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?

4 Replies

@natalie2220

What exactly is the problem?

S1422.png

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)

@Hans Vogelaar 

here is how it come out my side. 

BirthsAge @31/12/200731/12/2008
07/03/1990 17/01/190000/01/1900
best response confirmed by Sergei Baklan (MVP)
Solution

@natalie2220 

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

Thanks that worked!