Publish Custom Forms

Add a custom field and use one of the following formulas to calculate the age.

Using (Now() - [Birthday] ) /365 rounds the age to the closest age... less than 6 months until the next birthday and it reports the age at the next birthday, not the current age.

Example: The birth date is 8/15/1961. The short formula displays the age as 39, since the age is more than 38.5 years. (Today is 4/1/2000.)

 

 

This longer formula gives the exact date.. the age doesn't change until the birthday.

IIf([Birthday]<>"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d",CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())<0,1,0),"")

Download age contact example as a template or a zip

To change existing forms to use the Age form, try DocMessageClass, a free utility used to change forms used on Outlook items.