Return a persons age in years
Cell "A3" displays the date the person was born.
NOW - The date serial number of the current system date and time.
TODAY - The date serial number representing today's date.
TEXT - The number as a formatted text string.
YEARFRAC - The number of years as a decimal between two dates.
DATEDIF - (Compatibility) The number of days, months or years between two dates.
DATE - The date as a date serial number given a year, month, day.
INT - The number rounded down to the nearest integer.
User Defined Function
AGE - Returns the age of a person given a birthday.
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top