Thread: Age computation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
owen.cxy owen.cxy is offline
external usenet poster
 
Posts: 11
Default Age computation


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?