Spreadsheet: 722147d1615060047-add-1-to-a-given-value-in-every-3-years-based-on-a-range-of-dates-sample3
Sheet: Sheet1

 |  | From | To |  |  | From | To | Step
 |  | 1980-09-02 00:00:00 | 2005-03-10 00:00:00 |  |  | 1980-09-02 00:00:00 |  | 1 |  |  | 1980-12-31 00:00:00 | 1
 |  |  |  |  |  | 1981-01-01 00:00:00 |  | 1 |  | 1981-01-01 00:00:00 | 1981-12-31 00:00:00 | 1 |  | 1981-01-01 00:00:00 | 1982-01-01 00:00:00 | 1
 |  |  |  |  |  | 1982-01-01 00:00:00 |  | 1 |  | 1982-01-01 00:00:00 | 1982-12-31 00:00:00 | 1 |  | 1982-01-01 00:00:00 | 1983-01-01 00:00:00 | 1
 |  |  |  |  |  | 1983-01-01 00:00:00 | 1983-09-01 00:00:00 | 1 |  | 1983-01-01 00:00:00 | 1983-09-01 00:00:00 | 1 |  | 1983-01-01 00:00:00 | 1983-09-02 00:00:00 | 1
 |  |  |  |  |  | 1983-09-02 00:00:00 | 1983-12-21 00:00:00 | 2 |  | 1983-09-02 00:00:00 | 1983-12-31 00:00:00 | 2 |  | 1983-09-02 00:00:00 | 1984-01-01 00:00:00 | 2
 |  |  |  |  |  | 1984-01-01 00:00:00 |  | 2 |  | 1984-01-01 00:00:00 | 1984-12-31 00:00:00 | 2 |  | 1984-01-01 00:00:00 | 1985-01-01 00:00:00 | 2
 |  |  |  |  |  | 1985-01-01 00:00:00 |  | 2 |  | 1985-01-01 00:00:00 | 1985-12-31 00:00:00 | 2 |  | 1985-01-01 00:00:00 | 1986-01-01 00:00:00 | 2
 |  |  |  |  |  | 1986-01-01 00:00:00 | 1986-09-01 00:00:00 | 2 |  | 1986-01-01 00:00:00 | 1986-09-01 00:00:00 | 2 |  | 1986-01-01 00:00:00 | 1986-09-02 00:00:00 | 2
There will be an additional 1 step in every 3 years but not exceeding 8 with font color red. The cells filled with green are the end dates in each period. |  |  |  |  |  | 1986-09-02 00:00:00 |  | 3 |  | 1986-09-02 00:00:00 | 1986-12-31 00:00:00 | 3 |  | 1986-09-02 00:00:00 | 1987-01-01 00:00:00 | 3
 |  |  |  |  |  | 1987-01-01 00:00:00 |  | 3 |  | 1987-01-01 00:00:00 | 1987-12-31 00:00:00 | 3 |  | 1987-01-01 00:00:00 | 1988-01-01 00:00:00 | 3
 |  |  |  |  |  | 1988-01-01 00:00:00 |  | 3 |  | 1988-01-01 00:00:00 | 1988-12-31 00:00:00 | 3 |  | 1988-01-01 00:00:00 | 1989-01-01 00:00:00 | 3
 |  |  |  |  |  | 1989-01-01 00:00:00 | 1989-09-01 00:00:00 | 3 |  | 1989-01-01 00:00:00 | 1989-09-01 00:00:00 | 3 |  | 1989-01-01 00:00:00 | 1989-09-02 00:00:00 | 3
 |  |  |  |  |  | 1989-09-02 00:00:00 |  | 4 |  | 1989-09-02 00:00:00 | 1989-12-31 00:00:00 | 4 |  | 1989-09-02 00:00:00 | 1990-01-01 00:00:00 | 4
 |  |  |  |  |  | 1990-01-01 00:00:00 |  | 4 |  | 1990-01-01 00:00:00 | 1990-12-31 00:00:00 | 4 |  | 1990-01-01 00:00:00 | 1991-01-01 00:00:00 | 4
 |  |  |  |  |  | 1991-01-01 00:00:00 |  | 4 |  | 1991-01-01 00:00:00 | 1991-12-31 00:00:00 | 4 |  | 1991-01-01 00:00:00 | 1992-01-01 00:00:00 | 4
 |  |  |  |  |  | 1992-01-01 00:00:00 | 1992-09-01 00:00:00 | 4 |  | 1992-01-01 00:00:00 | 1992-09-01 00:00:00 | 4 |  | 1992-01-01 00:00:00 | 1992-09-02 00:00:00 | 4
 |  |  |  |  |  | 1992-09-02 00:00:00 |  | 5 |  | 1992-09-02 00:00:00 | 1992-12-31 00:00:00 | 5 |  | 1992-09-02 00:00:00 | 1993-01-01 00:00:00 | 5
 |  |  |  |  |  | 1993-01-01 00:00:00 |  | 5 |  | 1993-01-01 00:00:00 | 1993-12-31 00:00:00 | 5 |  | 1993-01-01 00:00:00 | 1994-01-01 00:00:00 | 5
 |  |  |  |  |  | 1994-01-01 00:00:00 |  | 5 |  | 1994-01-01 00:00:00 | 1994-12-31 00:00:00 | 5 |  | 1994-01-01 00:00:00 | 1995-01-01 00:00:00 | 5
 |  |  |  |  |  | 1995-01-01 00:00:00 | 1995-09-01 00:00:00 | 5 |  | 1995-01-01 00:00:00 | 1995-09-01 00:00:00 | 5 |  | 1995-01-01 00:00:00 | 1995-09-02 00:00:00 | 5
 |  |  |  |  |  | 1995-09-02 00:00:00 |  | 6 |  | 1995-09-02 00:00:00 | 1995-12-31 00:00:00 | 6 |  | 1995-09-02 00:00:00 | 1996-01-01 00:00:00 | 6
 |  |  |  |  |  | 1996-01-01 00:00:00 |  | 6 |  | 1996-01-01 00:00:00 | 1996-12-31 00:00:00 | 6 |  | 1996-01-01 00:00:00 | 1997-01-01 00:00:00 | 6
 |  |  |  |  |  | 1997-01-01 00:00:00 |  | 6 |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00 | 6 |  | 1997-01-01 00:00:00 | 1998-01-01 00:00:00 | 6
 |  |  |  |  |  | 1998-01-01 00:00:00 | 1998-09-01 00:00:00 | 6 |  | 1998-01-01 00:00:00 | 1998-09-01 00:00:00 | 6 |  | 1998-01-01 00:00:00 | 1998-09-02 00:00:00 | 6
 |  |  |  |  |  | 1998-09-02 00:00:00 |  | 7 |  | 1998-09-02 00:00:00 | 1998-12-31 00:00:00 | 7 |  | 1998-09-02 00:00:00 | 1999-01-01 00:00:00 | 7
 |  |  |  |  |  | 1999-01-01 00:00:00 |  | 7 |  | 1999-01-01 00:00:00 | 1999-12-31 00:00:00 | 7 |  | 1999-01-01 00:00:00 | 2000-01-01 00:00:00 | 7
 |  |  |  |  |  | 2000-01-01 00:00:00 |  | 7 |  | 2000-01-01 00:00:00 | 2000-12-31 00:00:00 | 7 |  | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | 7
 |  |  |  |  |  | 2001-01-01 00:00:00 | 2001-09-01 00:00:00 | 7 |  | 2001-01-01 00:00:00 | 2001-09-01 00:00:00 | 7 |  | 2001-01-01 00:00:00 | 2001-09-02 00:00:00 | 7
 |  |  |  |  |  | 2001-09-02 00:00:00 |  | 8 |  | 2001-09-02 00:00:00 | 2001-12-31 00:00:00 | 8 |  | 2001-09-02 00:00:00 | 2002-01-01 00:00:00 | 8
 |  |  |  |  |  | 2002-01-01 00:00:00 |  | 8 |  | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 8 |  | 2002-01-01 00:00:00 | 2003-01-01 00:00:00 | 8
 |  |  |  |  |  | 2003-01-01 00:00:00 |  | 8 |  | 2003-01-01 00:00:00 | 2003-12-31 00:00:00 | 8 |  | 2003-01-01 00:00:00 | 2004-01-01 00:00:00 | 8
 |  |  |  |  |  | 2004-01-01 00:00:00 |  | 8 |  | 2004-01-01 00:00:00 | 2004-12-31 00:00:00 | 8 |  | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 8
 |  |  |  |  |  | 2005-01-01 00:00:00 | 2005-03-10 00:00:00 | 8 |  | 2005-01-01 00:00:00 | 2005-03-10 00:00:00 | 8 |  | 2005-01-01 00:00:00 | 2005-03-10 00:00:00 | 8