Generating Calender in Excel giving start & end dates

[venkateswaran.v]

Hi,
I would like to create a calendar in excel worksheet. The input is i
give a start date & a end date. with this i would like to generate the
dates between these 2 dates & also roll them up to years.

Example:
Start Date 1-Jun-04
End Date 31-Dec-10

I need in this format
Date Week Period Qtr Year

 

[Duke Carey]

If you have either MSDE or SQL Server Express, the code provided at this link
will generate a table that looks very similar to what you want. You can then
import the details from SQL to Excel

http://sqlserver2000.databases.aspf...nsider-using-an-auxiliary-calendar-table.html