How do I calculate an age from a date of birth in 1 column & place the age in another in Numbers iOS 12

Good catch, Jason!

I use DATEDIF like this for years and months

Formula in C2 =DATEDIF(B2,TODAY(),"Y")&"y "&DATEDIF(B2,TODAY(),"YM")&"m"

Regards,

Ian.

When you try to do a calculation where you subtract dates, Numbers tries to force you to use a duration, but that typically gives me weeks. And 2481 weeks isnt how we think about age.

So what i typically do is strip the duration (literally the function is StripDuration) and then divide by 365.25

=stripduration(now()-C2)/365.25

If you want to get to just age in years, dont use round, that will round up if they are closer than 6 months to their next birthday. Use FLoor.

=floor(stripduration(now()-C2)/365.25,1)

the number one at the end is the "factor" basically what multiple a number do you want to go down to. in this case the closest multiple of 1.

Thanks

Jason

There's actually a much easier method that is not available in other spreadsheets that i didnt even think of til just now. (menacing i work in excel all day and it doesn't have this function available, so its not on the top of my head usually)

DateDiff

=Datediff(C2,Now(),"Y")

should give you exactly what you need.

Jason