## Create a list of dates with blanks between quarters in excel

*Article last updated on May 10, 2011*

**Question:** How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4)

**Answer:**

### Formula in A2:

Array formula in A3:

copied down as far as necessary.

**Jarek comments:**

*Create a list of 3 months in a quarter**Select it together with a blank cell benneath**Drag down*

*Thanks!*

### 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:**

**IF(**logical_test;[value_if:true];[value_if_false]**)
**Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

**ROUND**(number, num_digits**)**

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

Formula for matching a date within a date range

Table of contents Match a date when a date range is entered in a single cell Match a date when […]

The image above demonstrates an array formula in cell E4 that searches for the closest date in column A to the […]

Highlight overlapping date ranges using conditional formatting

The image above demonstrates a conditional formatting formula that colors a record if there is at least one record that […]

Identify overlapping date ranges

The formula in cell F6 returns TRUE if the date range on the same row overlaps another date range in […]

Highlight records based on overlapping date ranges and a condition

adam asks: Hi, I have a situation where I want to count if this value is duplicate and if it […]

I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me […]

Table of contents Initials from first and last names Initials from first, middle and last names Create middle name initials […]

Convert array formula to a regular formula

Kamran Mumtaz asked: Is there any way to use VLOOKUP for multiple criteria and I do not want to use CSE?; […]

During 2012 this website had almost 1 200 000 visitors, a 95% increase. It got hit by the google algorithm […]

### 6 Responses to “Create a list of dates with blanks between quarters in excel”

### Leave a Reply

### How to comment

**How to add a formula to your comment**

<code>Insert your formula here.</code>

**Convert less than and larger than signs**

Use html character entities instead of less than and larger than signs.

< becomes < and > becomes >

**How to add VBA code to your comment**

[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org or imgur

Use the img tag, like this: <img src="Insert pic link here">

**Contact Oscar**

You can contact me through this contact form

The question of exactly *why* you would want blank rows in your data remains unanswered.

I guess it would increase sheet readability in large lists.

I just try to solve peoples excel questions. If the solutions seem useful I post them here.

why not simply create a list of 3 months in a quarter

then select it together with a blank cell benneath

then drag down

?

Jarek,

your answer to this question is the easiest one. Thanks for your contribution!

welcome, any time

;-)

credit to my boss - I once tried to show him a similar formula solution. he listened and presented me a solution of his own (as above). I was devastated.

;-)

Dear

How can I change the formula, inserting blanks between each group :

(no macro please, shared file, users forget to enable macro's)

link to image :

https://s24.postimg.org/smz0khqc5/Blank_between_groups.jpg

Thanks for your help

Oliver