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 -


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=529274