Enter a complete date (9/1/2006) in B1. In C1: =eomonth(b1,0)+1. Copy that
formula across into as many columns as you need. Then format as you like (to
get the format you showed below, Format Cells, select the Number tab then
the Custom category; enter mm/yyyy in the text box and click ok).
--Bruce

"TNH" wrote:

I am trying to create a function where the first column is a mm/yyyy variable
and subsequent columns are the nextr months in the series. So 09/2006 in
first column and subsequesnt columns are 10/2006; 11/2006 etc. If I change
the start date (09/2006? I want the others to be updated automatically
through the spreadsheet.