Calculate age

From LemonWiki共筆
Revision as of 14:01, 10 February 2022 by Planetoid (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Calculate age in Excel or MySQL

Calculate age in Excel

If the column value is well-formatted

  • =(TODAY()- BIRTH_DAY)/365[1]

Calculate age in MySQL

SELECT `birth_date`, TIMESTAMPDIFF (YEAR, `birth_date`, CURDATE()) AS age
FROM `my_table` 
WHERE `birth_date` IS NOT NULL


Challenge of real world data

The column value is NOT well-formatted such as

  • year only e.g. 2022
  • month & date only e.g. 10-7