Year, Month, Days

[sajevan]

HELLO,

PLS. HELP ME WITH A FORMULA TO CALCULATE THE AGE FOR A PERSON.

THE DATE OF BIRTH IS 2.12.1969

(e-mail address removed)

 

[Norman Harker]

Hi Sajevan!

Use:
=DATEDIF(A1,TODAY(),"y") & " y " & DATEDIF(A1,TODAY(),"ym") & " m " &
DATEDIF(A1,TODAY(),"md") & " d"

Returns:
If 2.12.69 is 2-Dec-1969 34 y 5 m 21 d
If 2.12.69 is 12-Feb-1969 35 y 3 m 11 d

Just be aware of unusual returns where the birthday is on a day of the
month such as 31-Jan-2000 and you are asking for the age on (say)
1-Mar-2004 as it will return 4 y 1 m -1 d.

See:
Chip Pearson:
http://www.cpearson.com/excel/datedif.htm

 

[Rob van Gelder]

Check out Chip Pearson's page on Date Differences:
http://www.cpearson.com/excel/datedif.htm

Assuming A1 contains the date in question
B1: =TODAY()
C1: =DATEDIF(A1, B1, "y")
D1: =DATEDIF(A1, B1, "ym")
E1: =DATEDIF(A1, B1, "md")
F1: =C1 & " year" & LEFT("s", C1<>1) & ", " & D1 & " month" & LEFT("s",
D1<>1) & ", " & E1 & " day" & LEFT("s", E1<>1)