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