Thursday, January 15, 2015

MS Excel Formula for Calculate Age by Entering Date of Birth

Formula: =TRUNC((DAYS360(D1,today(), FALSE))/360, 0)

D1:  is your target cell for input date of birth
today(): is the formula to return the date of today




Then, the cell with this formula returns the age of input.



Easy!