Spreadsheet: 744663d1629373589-using-a-dynamic-formula-to-calculate-value-of-reinvested-dividends-over-time-periods-reinvested-dividend-forum-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | DIVIDEND INFORMATION
 | #[NAME]! |  |  |  | Date | Share Price | Share Return | Reinvested Dividend | Total Return Share Price |  |  | Ex-Dividend Date | Dividends
 |  |  |  |  |  |  |  |  |  |  |  | 2021-06-14 00:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  | 2021-03-15 00:00:00 | 2
 | Input |  |  |  |  |  |  |  |  |  |  | 2020-12-14 00:00:00 | 2
 | Period |  |  |  |  |  |  |  |  |  |  | 2020-09-14 00:00:00 | 2
 | Years | 5 |  |  |  |  |  |  |  |  |  | 2020-06-12 00:00:00 | 2
 | Months | 0 |  |  |  |  |  |  |  |  |  | 2020-03-13 00:00:00 | 2
 | Days | 0 |  |  |  |  |  |  |  |  |  | 2019-12-12 00:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  | 2019-09-11 00:00:00 | 2
 | Interval |  |  |  |  |  |  |  |  |  |  | 2019-06-11 00:00:00 | 2
 | Years | 0 |  |  |  |  |  |  |  |  |  | 2019-03-12 00:00:00 | 2
 | Months | 0 |  |  |  |  |  |  |  |  |  | 2018-12-11 00:00:00 | 2
 | Days | 1 |  |  |  |  |  |  |  |  |  | 2018-09-11 00:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  | 2018-06-12 00:00:00 | 2
 | STKHIS |  |  |  |  |  |  |  |  |  |  | 2018-03-13 00:00:00 | 2
 | Daily |  |  |  |  |  |  |  |  |  |  | 2017-12-12 00:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  | 2017-09-12 00:00:00 | 2
 | Output |  |  |  |  |  |  |  |  |  |  | 2017-06-12 00:00:00 | 2
 | End Period |  |  |  |  |  |  |  |  |  |  | 2017-03-13 00:00:00 | 2
 | Start Period |  |  |  |  |  |  |  |  |  |  | 2016-12-12 00:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  | 2016-09-12 00:00:00 | 1.8
 |  |  |  |  |  |  |  |  |  |  |  | 2016-06-13 00:00:00 | 1.8
 |  |  |  |  |  |  |  |  |  |  |  | 2016-03-14 00:00:00 | 1.7
 |  |  |  |  |  |  |  |  |  |  |  | 2015-12-11 00:00:00 | 1.7
 |  |  |  |  |  |  |  |  |  |  |  | 2015-09-11 00:00:00 | 1.7
 |  |  |  |  |  |  |  |  |  |  |  | 2015-06-11 00:00:00 | 1.7
 |  |  |  |  |  |  |  |  |  |  |  | 2015-03-12 00:00:00 | 1.4
 |  |  |  |  |  |  |  |  |  |  |  | 2014-12-11 00:00:00 | 1.4
 |  |  |  |  |  |  |  |  |  |  |  | 2014-09-11 00:00:00 | 1.4
 |  |  |  |  |  |  |  |  |  |  |  | 2014-06-11 00:00:00 | 1.4
 |  |  |  |  |  |  |  |  |  |  |  | 2014-03-12 00:00:00 | 1.4
 |  |  |  |  |  |  |  |  |  |  |  | 2013-12-11 00:00:00 | 1.4
 |  |  |  |  |  |  |  |  |  |  |  | 2013-09-11 00:00:00 | 1.25
 |  |  |  |  |  |  |  |  |  |  |  | 2013-06-10 00:00:00 | 1.25
 |  |  |  |  |  |  |  |  |  |  |  | 2013-03-11 00:00:00 | 1.25
 |  |  |  |  |  |  |  |  |  |  |  | 2012-12-10 00:00:00 | 1.1
 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-10 00:00:00 | 1.1
 |  |  |  |  |  |  |  |  |  |  |  | 2012-06-11 00:00:00 | 1.1
 |  |  |  |  |  |  |  |  |  |  |  | 2012-03-12 00:00:00 | 1.1
 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-12 00:00:00 | 0.95
 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-12 00:00:00 | 0.95
 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-13 00:00:00 | 0.95
 |  |  |  |  |  |  |  |  |  |  |  | 2011-03-11 00:00:00 | 0.8
 |  |  |  |  |  |  |  |  |  |  |  | 2010-12-13 00:00:00 | 0.8
 |  |  |  |  |  |  |  |  |  |  |  | 2010-09-13 00:00:00 | 0.8
 |  |  |  |  |  |  |  |  |  |  |  | 2010-06-11 00:00:00 | 0.8
 |  |  |  |  |  |  |  |  |  |  |  | 2010-03-11 00:00:00 | 0.65
 |  |  |  |  |  |  |  |  |  |  |  | 2009-12-11 00:00:00 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  | 2009-09-11 00:00:00 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  | 2009-06-11 00:00:00 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  | 2009-03-12 00:00:00 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  | 2008-12-11 00:00:00 | 1.15
 |  |  |  |  |  |  |  |  |  |  |  | 2008-09-11 00:00:00 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  | 2008-06-11 00:00:00 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  | 2008-03-12 00:00:00 | 0.55
 |  |  |  |  |  |  |  |  |  |  |  | 2007-12-11 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2007-09-10 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2007-06-13 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2007-03-13 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2006-12-13 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2006-09-13 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2006-05-31 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2006-03-13 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2005-12-13 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2005-09-13 00:00:00 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 2005-06-13 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2005-03-11 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2004-12-13 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2004-09-13 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2004-06-14 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2004-03-11 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2003-12-11 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2003-09-11 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2003-06-12 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2003-03-12 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2002-12-11 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2002-09-11 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2002-06-12 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2002-03-13 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2001-12-12 00:00:00 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  | 2001-09-17 00:00:00 | 0.8
 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-13 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 2001-03-13 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 2000-12-13 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 2000-09-13 00:00:00 | 0.82
 |  |  |  |  |  |  |  |  |  |  |  | 2000-06-13 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 2000-03-13 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1999-12-13 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1999-11-10 00:00:00 | 0.62
 |  |  |  |  |  |  |  |  |  |  |  | 1999-09-13 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1999-06-11 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1999-03-11 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1998-12-07 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1998-09-09 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1998-06-11 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1998-03-12 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1997-12-11 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1997-09-11 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1997-06-12 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1997-03-12 00:00:00 | 0.22
 |  |  |  |  |  |  |  |  |  |  |  | 1996-12-11 00:00:00 | 0.22