Telendrith
Reputation: 81
List of months between two dates as month & year
How do I get a dynamic list of months down a column between two dates in the month year format in Google Sheets?
example:
Start date: 5/18/2016
End date: 5/24/2019
Jan 2016
Feb 2016
Mar 2016
..
...
May 2019
Upvotes: 6
Views: 1995
Answers (1)
player0
Reputation: 1
=ARRAYFORMULA(UNIQUE(TEXT(TO_DATE(ROW(
INDIRECT("A"&DATEVALUE(B1)):
INDIRECT("B"&DATEVALUE(B2)))), "mmm yyyy")))
Upvotes: 7
Related Questions
- Generate array of dates with 1 month interval in Google Sheets
- How to calculate months with arrayformula in google script
- Populate all months between two dates
- Unique month+year combinations in Google Sheets
- Extract unique months from dates with year
- Find if a month belongs to a date range
- Get monthnames between 2 input dates and put them into an array
- Is there a Google Sheets formula or query to get an array of months within a date range?
- Array of month end dates between 2 dates
- How to get list of months for specific number of years?