View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Generating Calender in Excel giving start & end dates

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