You can calculate a persons age based on their birthday and todays date using Age Calculation formulas.
Method O1:
DATEDIF() function.
=DATEDIF(B1,TODAY(),-y-)
=DATEDIF(B1,TODAY(),-ym-)
=DATEDIF(B1,TODAY(),-md-)
Method 02:
=-Age is -&DATEDIF(C8,TODAY(),-y-)&- Years, -&DATEDIF(C8,TODAY(),-ym-)&- Months and -&DATEDIF(C8,TODAY(),-md-)&- Days-
Method 03:
=(TODAY()-B1)-365.25
Originally collected by
fetching...
(
less)