Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Date Ranges in Excel 2003
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generating Date Ranges in Excel 2003
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. wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
excel date scheduling not msProject | Excel Worksheet Functions | |||
Opening Excel 2003 files in Excel 97 | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
Generating a list from Excel 2003 | Excel Discussion (Misc queries) |