I need a formula to add a 75 years to a DOB

April 21, 2011 at 05:04:52
Specs: Windows XP
I need to calculate from a date of birth in cell A1: 29/02/2012 add a number of years i.e. 75 in cell A2 and display this date 29/02/2012 + 75years in cell A3

See More: I need a formula to add a 75 years to a DOB

Report •

#1
April 21, 2011 at 07:02:13
Will this work for you?

=DATE(YEAR(A1)+A2,MONTH(A1),DAY(A1))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question