Donate SIGN UP
Home > Technology > Any Excel or Quattro Pro experts?

Any Excel or Quattro Pro experts?

Avatar Image
ezapf | 19: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?
prev belarc hotfixes
  
next Blue screen problems
Gravatar

Answers

1 to 4 of 4rss feed

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.
Avatar Image 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.

19:56 Sun 16th Oct 2005
Avatar Image wideboy

Oops, typeing too fast again - should be assuming.

19:57 Sun 16th Oct 2005
Avatar Image wideboy
Oops, oops, typing!!!
19:57 Sun 16th Oct 2005
Avatar Image ezapf
Question Author

Yay!! It works! Thanks!

20:51 Sun 16th Oct 2005

1 to 4 of 4rss feed

Do you know the answer?

Any Excel or Quattro Pro experts?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.