I have a column in a spreadsheet that if I enter any given month in the first
cell, it will automatically list consecutive months after.

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

or

=EOMONTH(A1,1) require Analysis ToolPak Add-Ins

"Barbara" wrote:

I have a column in a spreadsheet that if I enter any given month in the first
cell, it will automatically list consecutive months after.

I enter a month into a cell and I drag down the fill handle to fill the column.

e.g. Jul will give me Aug, Sep, Oct etc. etc.

July will give me August, September, October etc. etc.

To fill a row, I drag the fill handle across the row.

Epinn

"Barbara" wrote in message ...
I have a column in a spreadsheet that if I enter any given month in the first
cell, it will automatically list consecutive months after.

If you want a formula you can try this.

=TEXT(DATEVALUE("28-"&A1&"-"&YEAR(TODAY()))+4,"mmmm")

Enter your month in A1. Enter the above formula in A2 and drag the fill handle down.

Thanks Bob for the formula.

Epinn

"Barbara" wrote in message ...
I have a column in a spreadsheet that if I enter any given month in the first
cell, it will automatically list consecutive months after.