Create a quartely date range in excel
Array formula in A4:
copied right as far as necessary.
Array formula in A7:
copied right as far as necessary.
Array formula in A10:
copied down as far as necessary.
Array formula in A17:
copied down as far as necessary.
Functions in this article:
ROW(reference) returns the rownumber of a reference
DATE(year,month,day) returns the number that represents the date in Microsoft Office Excel date-time code
TEXT(value, format_text)
Converts a value to text in a specific number format
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
Related articles:
- Create a weekly date range in excel
- Create a monthly date range in excel
- Create a custom date range in excel
Related posts:
Create a monthly date range in excel
Create a date range using excel formula
Create a custom date range in excel

















