Date Calculation?

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
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))
 
Back
Top