Calculate age

Copper Contributor

I'm trying to calculate the ages of group members using the "Today" function. Would anyone have any suggestions?

2 Replies

@Dougl5 If their DoB is in cell B2, this gives their age:

=DATEDIF(B2,TODAY(),"y")
Thank you....you are a lifesaver. I'm been wrestling with that question all morning.
You made my day,