F
f_ringberg
How can I in excel calculate the age if I have the person number
YYMMDD-xxxx?
500101-1234 --> 56
YYMMDD-xxxx?
500101-1234 --> 56
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
=DATEDIF(DATE(LEFT(A1,2),MID(A1,3,2),MID(A1,5,2)),TODAY(),"y")
F
f_ringberg
Datedif? I have excel swedish version, i don't find it...
B
Bernard Liengme
I have a dictionary of Excel functions which indicates that DATEDIF has the
same name in Swedish.
But you must have the Analysis Toolpac loaded
Also this is an unsupported function and it does not appear in Help
See http://www.cpearson.com/excel/datedif.htm
best wishes
same name in Swedish.
But you must have the Analysis Toolpac loaded
Also this is an unsupported function and it does not appear in Help
See http://www.cpearson.com/excel/datedif.htm
best wishes
F
f_ringberg
Thanks it works. If I can get the age from yymmdd-xxxx is it also
possible from xxxx to calculate if it's a male or female??
possible from xxxx to calculate if it's a male or female??
M
Michael Bednarek
Thanks it works. If I can get the age from yymmdd-xxxx is it also
possible from xxxx to calculate if it's a male or female??
Probably, if you tell us the rule. Odd/even for male/female? Ranges?