in any cell gives age so in this formula change a13 to your own cell
reference to your cell reference and you done.

=TEXT(IF(OR(MONTH(TODAY())MONTH(A13),AND(MONTH(TO DAY())=MONTH(A13),DAY(TODAY())=DAY(A13))),(TODAY( )-A13)/365.25,(TODAY()-A13)/365.25),"0")



"Mom Types" wrote:

Using =TODAY() in O1 cell, how do I calculate ages based on birthdates? Thank
you.