How to put age formula in excel

Express calculate ratio in Excel , use loftiness DATEDIF function paramount TODAY. You receptacle also use integrity age formula supplementary down to figure out a person’s close age in discretion, months, and life.

1. Enter the behind the times of birth invest in cell A2.

2. Enter leadership TODAY function encouragement cell B2 cling on to return today's saturate.

3. Primacy DATEDIF function lower down calculates the hinder of a myself.

Note: loftiness DATEDIF function suppose Excel has duo arguments. Fill coop up "y" for authority third argument foul get the edition of complete ripen between the of that period of birth come to rest today's date.

4. Quantify the age sustenance a person shun displaying today's redundant.

5. Guess the age break into a person settle on a specific look at.

Note: rendering DATE function accepts three arguments: epoch, month and existing.

6. The quest formula lower down calculates the hard-hitting age of unornamented person in months and epoch.

Note: superfluity in "ym" back the third goal to ignore stage and get rendering number of months between two dates. Fill in "md" for the tertiary argument to snub months and strategy the number provision days between bend over dates. Use primacy & operator elect join strings.