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-2024

Updated:  01/23/2024 13:34
This page added:  27 July 2015