Formula in A4:

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

Formula in A7:

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

Formula in A10:

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

Formula in A19:

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

Related articles:

• Create a weekly date range using excel formula
• Create a quartely date range in excel
• Create a custom date range in excel

Related posts:

1. Create a quartely 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. Create unique distinct year and months from a long date listing in excel
8. Lookup two index columns using min max values and a date range as criteria
9. Lookup min max values within a date range in excel
10. Largest value in a range using date criteria in excel