software

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: www.excelforum.com/member.php...oamp;userid=31616
View this thread: www.excelforum.com/showthread...hreadid=529274In A2 put

=DATE(YEAR(A1),MONTH(A1) 1,DAY(A1))

copy down as long as neededwill work as long as you don't use dates like 31/03/06 but since you said it
will always be the 19th
If you need to enter other dates like then 31st etc post back

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;martinsquot; gt; wrote in
message ...
gt;
gt; Can somebody tell me if this is possible - here is what I would like to
gt; do -
gt; Cell A1 contains a date which will always be the 19th of the month
gt; formatted for example as 19/01/06: in the cells that follow this i.e.
gt; A2 - A12 I would like the date to automatically appear based on the
gt; what has been typed in cell A1 - for example: if 19/02/06 is typed in
gt; cell A1, cell A2 returns 19/03/06, A3 returns 19/04/06 and so on -
gt;
gt; I have tried to create a formula which allows for 30 and 31days cycle
gt; but am getting nowhere - can anyone help -
gt;
gt;
gt; --
gt; martins
gt; ------------------------------------------------------------------------
gt; martins's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31616
gt; View this thread: www.excelforum.com/showthread...hreadid=529274
gt;

This works fine - but just wondered how would you also return Blank if
the cell A1 is in fact blank?

Many Thanks--
martins
------------------------------------------------------------------------
martins's Profile: www.excelforum.com/member.php...oamp;userid=31616
View this thread: www.excelforum.com/showthread...hreadid=529274
Please ignore last query - I have worked it out

However - if I wanted to return date formated as for example Apr-06 etc
in the cells following A1 - how would this look?

Thanks--
martins
------------------------------------------------------------------------
martins's Profile: www.excelforum.com/member.php...oamp;userid=31616
View this thread: www.excelforum.com/showthread...hreadid=529274