Spreadsheet Formulas

css navigation by Css3Menu.com

Age at New Year

I havenít added a juicy formula in a few years.

Somebody from HR came to me with her dilemma. Given a birthdate, how old was someone on the first day of the year.

Computer Age formula

=ROUNDDOWN((DATEVALUE("1/1/"&YEAR(NOW()))-D3)/365.25,0)

RoundDown to a whole number, a DateValue beginning with 1 January, and the current year. By using the NOW(), she will have the age when the year rolls around again. Dividing the whole thing by 365.25 accounts for Leap years. The final ō (zero) is to round to whole number.

© 2015-2016

Updated:  11/16/2016 19:50
This page added:  27 July 2015