I need to prepare a financial report whereby given a variable year-end date input in a cell (e.g. A1: 31.03.12)a formula will allow me to have a serie of the next 12 following month.
I cannot use A1+30 = 30.04.12 because of course if A1: was 30.04.12 will not work