Generating Date Ranges in Excel 2003

[jeremiah.meyers]

Hello everyone,

Hope everyone had a great holiday vacation!

Down to business though, I have an Excel 2003 Workbook and I need to
create a date range for example cell E1 will say "Week 1/4/2007 -
1/10/2007" and Cell F1 will have "Week 1/11/2007 - 1/17/2007" and so
on... Is there a way to automate this task using Macros or VBA?

Thanks in advance

Jeremiah

 

[Dave Peterson]

How about a formula:

="Week "&TEXT(DATE(2007,1,7*(COLUMN()-5)+4),"mm/dd/yyyy")&" - "
&TEXT(DATE(2007,1,7*(COLUMN()-5)+10),"mm/dd/yyyy")

You may like:

="Week "&CHAR(10)&TEXT(DATE(2007,1,7*(COLUMN()-5)+4),"mm/dd/yyyy")&CHAR(10)
&TEXT(DATE(2007,1,7*(COLUMN()-5)+10),"mm/dd/yyyy")

And turn on wraptext (format|Cells|alignment tab)

And then drag that formula to the right.