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
Recommended categories
need to truncate the undermentioned column to create columns of weeks it has, for eg. 1/26/2011 was a wed, so need a column for 1/26/2011-sun 1/29/2011, and then onwards each week starting monday till 8/31/2011. please help asap
Assigned Dates
1/26/2011 - 8/31/2011
2/1/2011 - 3/30/2011
2/1/2011 - 3/30/2011
2/1/2011 - 3/30/2011
11/1/2010 - 2/11/2011
1/26/2011 - 8/31/2011
Deeks,
read this post: Filter weeks from a date range