This one works the best for me; I have a list of clients/birthdates and this
formula worked the best in a Fill. Thanks for your help.

"Mike" wrote:

Sorry here's a nicer one. Once again change A1 to your own cell reference

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

"Mom Types" wrote:

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