View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] venkateswaran.v@gmail.com is offline
external usenet poster
 
Posts: 1
Default Generating Calender in Excel giving start & end dates

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