Age Calculator in MS Outlook 2002 SP3

Asked By 30 points N/A Posted on -
qa-featured

Hello,

I am trying to calculate age using Outlook 2002 SP3, but it does not appear to work using dd/mm/yyyy.

The code that I am using is;

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

Any suggestions? 

SHARE
Answered By 0 points N/A #144332

Age Calculator in MS Outlook 2002 SP3

qa-featured

Hi Jedonnel,

 I have this formula to calculate age of people using its birth date. Check it:

DATEDIF(BD,TODAY(),"Y") & " Years, " & DATEDIF(BD,TODAY(),"YM") & " Months, " & DATEDIF(BD,TODAY(),"MD") & " Days"

In above formula BD stands for Birthdate.

This formula age as per YYYY / MM/ DD you can change the order according to requirements.

Edward.

 

Login/Register to Answer

Related Questions