Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Age computation
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total Computation | Excel Programming | |||
computation error | Excel Discussion (Misc queries) | |||
Time Computation | Excel Discussion (Misc queries) | |||
What type of pc is best for computation | Excel Discussion (Misc queries) | |||
Help wanted with computation | Excel Programming |