use this in F1 and copy over

=IF(F2<0,DATE(YEAR(E1),MONTH(E1)+1,DAY(E1)),"")

It even automatically rolls the years (Month 13 kicks to the next year)

--
If this helps, please remember to click yes.


"C" wrote:

I have a date (MMM YY) entered into cell E1. I would like to increment by
month F1 Thru whenever data is no longer populated in row 2.

My Current spreadsheet:

E F G H I
Row1 Jun 10
Row2 $80 $1600 $1706 $272 $352


How I need to modify:
E F G H I
Row1 Jun 10 Jul 10 Aug 10 Sep 10 Oct 10
Row2 $80 $1600 $1706 $272 $352

The Data in Row 2 may extend to any column.

Any help is greatly appreciated.