Ask Your Question

Revision history [back]

To increment by years (or months) instead of days you need to select two cells that differ by one year (or month). For example, A1 23/11/2017 and A2 23/11/2018, select A1:A2 and pulling down yields 23/11/2019, 23/11/2020, ...