Thread: I want a formula to list months, from any given month, forward
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default I want a formula to list months, from any given month, forward
=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.
Reply With QuoteReply With Quote