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
---------------
Jacob Skaria


"owen.cxy" wrote:

> 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?