AUTOMATICALLY DATE COLUMNS WITH DIFFERENT DATES

[Guest]

I am making a spreadsheet with interest calulations for each month. Some
calculations can go as far back as 2004. I would like to know if there is a
formula or a way to format the cells so that each date can automatically the
end of the next month. For example, in cell A6 it would say 01/31/07, in A7
it would say 02/28/07 then in A8 it would be 3/31/07...and so on

 

[Peo Sjoblom]

If you put the first date manually in A6, then copy down using the right
mouse button then when you release the mouse button select fill months

Or you can use a formula in A7 and copy the formula down


=DATE(YEAR(A6),MONTH(A6)+2,0)


--


Regards,


Peo Sjoblom