Create a list of dates with blanks between quarters in excel
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
Related posts:
Create random dates, Mon to Fri, within a year in excel
Extract dates using a drop down list in excel
Excel: Calculate last date of a specific month
How to automatically create a unique distinct list and remove blanks
Create a unique distinct sorted list containing both numbers text removing blanks in excel
Recommended categories
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.