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)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"sajevan " wrote in message
...
HELLO,

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

THE DATE OF BIRTH IS 2.12.1969




---
Message posted from http://www.ExcelForum.com/