Date Calculation?

[Rob]

Excel 97

Have a spreadsheet with a column "number of years", i.e.
2.1 years, 0.8 years, 1.1 years, etc.

I am trying to add a date of 10/1/2003 + the "number of
years" together to give me the date of these two numbers
added together.

Can not get it to work, any idea's, thanks.

=(f2*365)+"10/1/2003" will not work

 

[Don Guillett]

what doesn't work. Did you format as date?

 

[Peo Sjoblom]

Assume that 10/1/2003 is in B1, to add 2 years to that use

=DATE(YEAR(B1)+2,MONTH(B1),DAY(B1))

if you have a number of years in A1

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

you can't however use decimal years, you have to split them
if you want to add 2 years and 3 months to 10/1/2003
(still with 10/1/2003 in B1)

=DATE(YEAR(B1)+2,MONTH(B1)+3,DAY(B1))