|
how do i calculate age in term of years, months, days
how do i calculate age in term of years, months, days
|
how do i calculate age in term of years, months, days
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 "shan" wrote in message ... how do i calculate age in term of years, months, days |
how do i calculate age in term of years, months, days
Hi Biff
Thank u, it works SHAN "Biff" wrote: 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 "shan" wrote in message ... how do i calculate age in term of years, months, days |
how do i calculate age in term of years, months, days
You're welcome. Thanks for the feedback!
Biff "shan" wrote in message ... Hi Biff Thank u, it works SHAN "Biff" wrote: 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 "shan" wrote in message ... how do i calculate age in term of years, months, days |
| All times are GMT +1. The time now is 12:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com