Can anyone tell me if there is an easy way to calculate age from a birthdate in a range of cells. For example, Birthdate is in column B, B2 to B110, and Age is in column C, C2 to C110. I'm using the following formula:
=DATEDIF(B2,TODAY(),"y")
I'm just wondering if there is an easier alternative than inputing and changing this formula for each cell. Thanks!
=DATEDIF(B2,TODAY(),"y")
I'm just wondering if there is an easier alternative than inputing and changing this formula for each cell. Thanks!