Dynamic Date Calculation - Possible to create a formula showingMember Age, based on B'day

  • Thread starter Thread starter Mike C
  • Start date Start date
M

Mike C

Hello is there a formula that will allow me to show the current age of
someone, based on what is entered as their birthday.

So the columns would be

Member age B'day
Formula here Typed in manually here.

It would preferable for the Member age to be dynamic, so that as time
progresses, the age will update automatically....if that is possible.

Thanks for any suggestions.
 
Hey Mike C

you could use this formula, where the birthday is in B2:

=YEAR(TODAY())-YEAR(B2)-
IF(TODAY()>=DATE(YEAR(TODAY()),MONTH(B2),DAY(B2)),0,1)

I guess there's a shorter formula, but at least it works :)

hth
Carlo
 
With
A1: (BirthDate)

This formula returns the number of whole years (Age)
between that date and today:

B1: =DATEDIF(A1,TODAY(),"y")&" years"

For more information, see Chip Pearson's coverage
of Excel's (mostly) undocumented DATEDIF function:
http://www.cpearson.com/excel/datedif.htm

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Back
Top