adding date in excel

  • Thread starter Thread starter ferozms
  • Start date Start date
F

ferozms

I would like to know how to add a year to a date. If a persons date o
birth is
14/11/1976 and he would retire from service at the age of 55. I woul
like to add 55 years to his date of birth 14/11/1976 + 55. How would
do this calculation.

fero
 
I would like to know how to add a year to a date. If a persons date of
birth is
14/11/1976 and he would retire from service at the age of 55. I would
like to add 55 years to his date of birth 14/11/1976 + 55. How would i
do this calculation.

feroz
Click to expand...


=DATE(YEAR(DOB)+55,MONTH(DOB),DAY(DOB))


--ron
 
With the birthdate in A1:

=date(year(a1)+55,month(a1),day(a1))

This will fail if the birthday is February 29. 55 years later won't be a
leapyear.
 
Back
Top