I'm new to formulas and functions. I'm trying to figure out a formula that
can figure out your age when given a Birthday.

Anyone?

Heres a real quick one.

Field Name 1
B_Day
(Format: Date)

Field Name 2
Calc Age
(Format: Calculation) Int((Status( CurrentDate)-B_Day)/365.25)

"Steve McGillivray" <steve.mcgillivray (AT) asu (DOT) edu> wrote

AgeYears (calculation, number) =

Year (Status (CurrentDate)) - Year (Birthday) -
(Month (Status (CurrentDate)) < Month (Birthday)) -
((Month (Status (CurrentDate)) = Month (Birthday)) and
(Day (Status (CurrentDate)) < Day (Birthday)))


"Steve McGillivray" <steve.mcgillivray (AT) asu (DOT) edu> wrote

Here's one more for the mix.

Year(Status(CurrentDate)) - Year(DOB) - (DayofYear(Status(CurrentDate))
< DayofYear(DOB))

Michael Myett


Steve McGillivray wrote:

lots of ways to skin this cat..eh?

rqo

"Michael Myett" <michael.myett (AT) verizon (DOT) net> wrote

Yes and no.

Be careful, using a formula that simply divides by 365.25 will cause
problems on leap years and using a formula that doesn't take into
account if the birthdate has occured this year or not will give
incorrect results in some circumstances.

Michael Myett

rqo wrote:

Thank you all. It is interesting to see the different ways to tackle a
problem.

Please see my new post for another formula. I think it's a little trickier.

Steve McGillivray