How to calculate age in NUMBERS
Random question. Thanks to another user, I am using this formula =DATEDIF($A2,TODAY(),"Y") to calculate age on a Numbers doc which says it's calculating from 'TODAY'. I am guessing it's going from my computers calendar? Or can someone tell me where is it referencing the TODAY? Are all apple computers sync'd to the right date/time?
I am curious if I ever share the document for someone else to update (another section), could there a possibility that their computer messes up the years because their computer clock is off? Or are all Apple computers constantly sync'd to the clock? Could they view the ages incorrectly?
I have barely used Numbers but today it suddenly seems so much more user friendly than sheets or excel - especially in the way it responds in HELP. So thank you Apple!
MacBook Pro 13″, macOS 14.6