how do i calculate age in term of years, months, days
B Biff Mar 15, 2006 #2 Hi! Try this: A1 = birthdate B1 = =NOW() Formula for the age: =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days" Will return something like: 29 years, 10 months, 11 days Biff
Hi! Try this: A1 = birthdate B1 = =NOW() Formula for the age: =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days" Will return something like: 29 years, 10 months, 11 days Biff
G Guest Mar 15, 2006 #3 Hi Biff Thank u, it works SHAN Biff said: Hi! Try this: A1 = birthdate B1 = =NOW() Formula for the age: =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days" Will return something like: 29 years, 10 months, 11 days Biff Click to expand...
Hi Biff Thank u, it works SHAN Biff said: Hi! Try this: A1 = birthdate B1 = =NOW() Formula for the age: =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days" Will return something like: 29 years, 10 months, 11 days Biff Click to expand...
B Biff Mar 15, 2006 #4 You're welcome. Thanks for the feedback! Biff shan said: Hi Biff Thank u, it works SHAN Click to expand...
You're welcome. Thanks for the feedback! Biff shan said: Hi Biff Thank u, it works SHAN Click to expand...