Question: How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4)
Formula in A2:
Array formula in A3:
copied down as far as necessary.
- Create a list of 3 months in a quarter
- Select it together with a blank cell benneath
- Drag down
Download excel sample file for this tutorial.
Create a list of dates with blanks between quarters.xls
(Excel 2007 Workbook *.xlsx)
Functions in this article:
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Rounds a number to a specified number of digits
DATE(year,month,day) returns the number that represents the datein Microsoft Office Excel date-time code
MONTH(serial_number) returns the month, a number from 1 (January) to 12 (December)
YEAR(serial_number) returns the year of a date, an integer of the range 1900-9999