Type the start and end date of the first quarterly date range in row 3. Type the second date range in row 4, see picture below.
Select cell range B3:C4. Click and hold on the black dot.
Drag to cells below as far as needed.
Excel automatically creates the following date ranges using the selected cells as a guide to determine the range and starting point.
Quarterly date ranges using a formula
You also have the option to build a date range using formulas. I have entered 1/1/2017 in cell B3 and the following formula in cell C3:
See picture below. The formula adds 3 months to the date in cell B3 and then subtracts 1 to get the last date for the first quarterly date range. This setup takes into account that months have 30 or 31 days.
Type this formula in cell B4:
It is almost identical to the formula in cell C3. Then copy cell C3 and paste to cell C4.
Now select cell range B4:C4 and click and hold on black dot, see picture above.
Drag to cells below as far as needed. This action copies the formulas in cell range B4:C4 and pastes them to cells below.
Date ranges in one cell each
The following picture shows date ranges in a cell each, to achieve that we need to build a somewhat more complicated formula. The formulas in cell A4 and A7 must be copied to cells to the right of the start cell.