The responses were a good start and I am trying to adapt them to my
particular sheet on my own but maybe I can get more help.

The spreadsheet I am working with looks like this:

Col A Col B Col C
Col D Col D.....

Row 1 Date From Date To Consumption Jan.
04 Feb.04..

Row 2 dd-mm-yyyy dd-mm-yyyy a number

Row 3 another entry

Row 4 another entry

I had exported the data from an ACCESS database such that I have one
worksheet for each month based on the "Date To" Column (Col C). Therefore
the "Date To" will always be the same month but not necessarily the same day.
The "Date From" can range from years previous to the same month. If, for
example, the dates are 17-Oct-2001 to 31-Jan-2004 I don't (necessarily) need
to break down days in months not in 2004. I think its too difficult because
each entry needs different headers so I would like to fix the header row to
Jan. 04, Feb. 04, etc.

Again thanks for your help. And I'll keep trying to figure it out too.