quartely date range

Array formula in A4:

=TEXT(DATE(2009, IF(COLUMN(A:A)=1, 1, COLUMN(A:A)*3-2),  1),  "MM/DD/YY")&"-"&TEXT(DATE(2009, COLUMN(A:A)*3+1,  1)-1,  "MM/DD/YY") + ENTER copied right as far as necessary.

Array formula in A7:

=TEXT(DATE(2009, IF(COLUMN(A:A)=1, 1, 1-(COLUMN(A:A)-1)*3),  1),  "MM/DD/YY")&"-"&TEXT(DATE(2009, IF(COLUMN(A:A)=1, 4, 0-(COLUMN(A:A)-2)*3+1),  1)-1,  "MM/DD/YY") + ENTER copied right as far as necessary.

Array formula in A10:

=TEXT(DATE(2009, IF(ROW(1:1)=1, 1, ROW(1:1)*3-2),  1),  "MM/DD/YY")&"-"&TEXT(DATE(2009, ROW(1:1)*3+1,  1)-1,  "MM/DD/YY") + ENTER copied down as far as necessary.

Array formula in A17:

=TEXT(DATE(2009, IF(ROW(1:1)=1, 1, 1-(ROW(1:1)-1)*3),  1),  "MM/DD/YY")&"-"&TEXT(DATE(2009, IF(ROW(1:1)=1, 4, 0-(ROW(1:1)-2)*3+1),  1)-1,  "MM/DD/YY") + ENTER 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:

  • Share/Bookmark

Related posts:

  1. Create a monthly date range in excel
  2. Create a date range using excel formula
  3. Create a custom date range in excel
  4. Create a unique distinct list from a date range in excel
  5. Formula for matching a date within a date range in excel
  6. Extract dates and adjacent value in a range using a date critera in excel
  7. Lookup two index columns using min max values and a date range as criteria
  8. Lookup min max values within a date range in excel
  9. Largest value in a range using date criteria in excel
  10. How to calculate missing months in a given date range in excel