View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Epinn Epinn is offline
external usenet poster
 
Posts: 605
Default 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.