Formula to calculate a Contacts "Age" (in years) from "Birthdate"

[KrishOnan]

Can someone help me?
Thanks in advance!

[susieb]

ROUND( (TODAY() - {!BirthDate} )/365,1),

[KrishOnan]

Thanks!!

[AJ yorkshire · Accepted solution]

You will find that this will round to the nearest year rather then give the actual age. To calculate the exact age (not rounding up or down to the nearest year). Use the following formula.

IF ( OR ( MONTH ( {!Birthdate} ) > MONTH (TODAY()), AND( MONTH ( {!Birthdate} ) = MONTH (TODAY()), DAY ( {!Birthdate} ) >= DAY (TODAY()+1))), YEAR (TODAY()) - YEAR ( {!Birthdate} ) -1, YEAR (TODAY()) - YEAR ( {!Birthdate} )) 

[DEManhong]

Excel has a specific DATEDIF function, used mainly for calculating ages




For Example

DATEDIF(start_date,end_date,unit) >>>  =DATEDIF(( {!Birthdate} ),TODAY(),"y")
You can specify the formula to show Years (y), Months (ym) and Days (md).

Message Edited by DEManhong on 08-02-2006 06:09 AM

[jisaac]

This is really great, but could you show me what the formula needs to be to calculate the remaining number of months in a contract? We sell add-on's to exisiting contracts so the add-on needs to have a coterminous contract expiration date.

I have a field called Core Contract Exp. Date that I would like to use as the basis. Then we would compare it to the Close Date in order to get the Months remaining in Contract.  I'm just a little think to figure it out on my own and would really appreicate your help.

Thanks,

Jane