I want a formula to list months, from any given month, forward

B

Barbara

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.
 
T

Teethless mama

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

or

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

Epinn

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

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.
 
E

Epinn

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

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