Age computation

  • Thread starter Thread starter owen.cxy
  • Start date Start date
O

owen.cxy

Hi, I'm trying to compute age and currently using Excel 2007

On one column, I have the "date of birth column" in the format of
dd/mm/yyyy. On the other I have the "Age column" with the formula shown below:

=DATEDIF(B6,TODAY(),"y")&" years "&DATEDIF(B6,TODAY(),"ym")&" months
"&DATEDIF(B6,TODAY(),"md")&" days"

However, it keeps showing the value of 0 throughout the whole "Age column".
Why is this so and what solutions lies ahead?
 
Try the below in a new sheet

Put DOB in A1

In B1 enter the below formula

=IF(A1+0=0,"",DATEDIF(A1,TODAY(),"y")&" years "&DATEDIF(A1,TODAY(),"ym")&"
months " & DATEDIF(A1,TODAY(),"md")&" days")

If this post helps click Yes
 
Back
Top