Constructing safe dates with DATE(Y, M, D), extracting day/month/year components, and calculating complete elapsed years, months, and days with DATEDIF.
“7.2 DATE, DAY, MONTH, YEAR & DATEDIF Age Calculations” is part of Formulas That Do the Work. Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.
