Any Excel or Quattro Pro experts?

ezapf | 18:37 Sun 16th Oct 2005 | Technology

4 Answers

I am making a spreadsheet and I have a column with dates. I want the next column to show the date exactly 17 years later. Is there a way to make the spreadsheet fill in the second column automatically?

belarc hotfixes

Blue screen problems

Answers

1 to 4 of 4

Best Answer

No best answer has yet been selected by ezapf. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

wideboy

Assumong the date is in A1 and the number of years is in G1 then you can use the formula:-

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

or you can just use 17 in the formula instead of G1

This is from the online help using Date, then add dates and go on from there.

wideboy

Oops, typeing too fast again - should be assuming.

wideboy

Oops, oops, typing!!!

ezapf

Question Author

Yay!! It works! Thanks!

1 to 4 of 4

Do you know the answer?