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.aspfa...dar-table.html
" wrote:
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