Create a monthly date range in excel

Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.

Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.

You are here: Home >> Excel >> Dates >> Create a monthly date range in excel

=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.

=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.

=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.

=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.

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

Deeks Says:
December 19th, 2011 at 2:50 pm

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
Oscar Says:
December 23rd, 2011 at 3:01 pm

Deeks,
read this post: Filter weeks from a date range

Related blog posts