Articles

Solved date advance in Excel

December 10, 2012 at 15:08:51
Specs: Windows 7

I have entered dates in Column A, what formula do I use to automaticaly advance the date 10 years in Column B?

See More: date advance in Excel

Report •


#1
December 10, 2012 at 15:32:54
✔ Best Answer

Try this:

With your start date in cell A1

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

Also, Excel questions are best asked in the Office Software Forum.

MIKE

http://www.skeptic.com/


Report •

#2
December 11, 2012 at 11:25:38

thank you!

Report •

Related Solutions


Ask Question