G
Guest
Format a cell, say A1, with style of date of your choosing
and enter birthdate accordingly. In the adjacent cell
type the following formula: =A1+70.5*365.25 and the
answer should pop up in the same date format. The date
function works off of days, so you need to multiply the
years by 365.25 days per year.
and enter birthdate accordingly. In the adjacent cell
type the following formula: =A1+70.5*365.25 and the
answer should pop up in the same date format. The date
function works off of days, so you need to multiply the
years by 365.25 days per year.