I want a formula to list months, from any given month, forward
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.
|