Age computation

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

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totalling Formulas 1
Calculate age with an end date 3
Excel formula calculating age 4
date of birth age formula 8
changed DOB to age, but if no DOB need cell to be empty. 4
Totaling DATEDIF SUMS 4
Age Formula 4
Update Upon Opening based on DATEIF NOW() 10

Top