Create a monthly date range in excel
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:
- Create a quartely date range in excel
- Create a date range using excel formula
- Create a custom date range in excel
- Create a unique distinct list from a date range in excel
- Formula for matching a date within a date range in excel
- Extract dates and adjacent value in a range using a date critera in excel
- Create unique distinct year and months from a long date listing in excel
- Lookup two index columns using min max values and a date range as criteria
- Lookup min max values within a date range in excel
- Largest value in a range using date criteria in excel



Leave a Reply