AUTOMATICALLY DATE COLUMNS WITH DIFFERENT DATES

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top