i started trying to answer a question in mocrosoft forums which has gone a long way today and this is my third editing of the post.
How to calculate age in a sharepoint list with only date of birth available.
it can be done with the formula listed below :
Now i will explain what the fields are:
DOB- date of birth Field in the sharepoint list.
Todaysdate - gives you the date today but need to carry difficult step to get it. you cannot get todays date directly anywhere in sharepoint list, thats sure.
i got it via, the steps given at :
now what the formula does :
First it takes the difference between todays date and DOB. then substracts the no of leap years from it, divide it by 365 and took a round value.