How do you add 18 years to a date in Excel?
If your date is in cell A1 this formula will do it for you:
=DATE(YEAR(A1)+18,MONTH(A1),DAY(A1))
--
Kevin Backmann
"Janelle Lister" wrote:
I'm trying to calculate the date of a person's 18th birthday using a formula
in Excel. For example, if the birthdate is January 1, 2000 the age of
majority is January 1, 2018. What formula can I enter to have Excel
calculate the date for me?
|