Age Calculator in MS Outlook 2002 SP3

Asked By Jdonnel 30 points N/A Posted on - 02/26/2013

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? 

• Status: Open
• Question Views: 695
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Outlook

Answered By Edward_Weary 0 points N/A #144332

Age Calculator in MS Outlook 2002 SP3

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.

 

About Edward_Weary

Questions
3

Answers
35

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 03/05/2013
• Question Category: MS Outlook