If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Age Formula
I need a formula that takes the Date of Birth and returns
the age. I am using this one: =(DAYS360(A2,TODAY ()))/365, but I want to know if there is a better way. Thanks, Deiby |
#2
|
|||
|
|||
Age Formula
Deiby, have a look here
http://www.cpearson.com/excel/datedif.htm#Age -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "Deiby Quezada" wrote in message ... I need a formula that takes the Date of Birth and returns the age. I am using this one: =(DAYS360(A2,TODAY ()))/365, but I want to know if there is a better way. Thanks, Deiby |
Thread Tools | |
Display Modes | |
|
|