G Guest Oct 6, 2006 #1 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 have a column in a spreadsheet that if I enter any given month in the first cell, it will automatically list consecutive months after.
G Guest Oct 6, 2006 #2 =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) or =EOMONTH(A1,1) require Analysis ToolPak Add-Ins
E Epinn Oct 6, 2006 #3 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.
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 Oct 6, 2006 #4 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.
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.
