Can somebody tell me if this is possible - here is what I would like to do -
Cell A1 contains a date which will always be the 19th of the month formatted for example as 19/01/06: in the cells that follow this i.e. A2 - A12 I would like the date to automatically appear based on the what has been typed in cell A1 - for example: if 19/02/06 is typed in cell A1, cell A2 returns 19/03/06, A3 returns 19/04/06 and so on -

I have tried to create a formula which allows for 30 and 31days cycle but am getting nowhere - can anyone help -