Year, Month, Days
 

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

Year, Month, Days
 

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Year, Month, Days
 

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/