Bart,

This solution assumes the following:

Your chasis numbers are in column A, starting in row 3, your entry dates are in column B, starting
in row 3, and your exit dates are in column C, starting in row 3. In row 2, starting in column D,
you have the dates for the first of the month, for the time period that you are interested in: Aug
1 06, Sep 1 06, etc. Format as custom mmmm yy to show just the month name and year, if you like...

Then in cell D3, enter the formula

=IF(AND($B3<D$2,$C3<D$2),0,IF(AND($B3<=D$2,$C3=E$ 2),E$2-D$2,IF(AND($B3<=E$2,$C3=E$2),E$2-$B3,IF(AND($B3<=D$2,$C3<=E$2),$C3-D$2+1,IF(AND($B3=D$2,$C3<=E$2),$C3-$B3,0)))))

Watch the line wrapping....

Copy that formula down as far as you need (to match your data rows), then copy across to match the
dates in row 3. You will get a table of the days for each month for each chasis number.

HTH,
Bernie
MS Excel MVP


"Bart" wrote in message
ups.com...
Hi,

I have a sheet with collums for entry date and exit date used in a car-
compound. I also have a collumn for each month of the year.

What I am trying to do is let excel (VBA) calculate how many days a
car was on the compound in every month. This is a monthly/yearly
ocurring item to check the invoicing.

What I'd like to do is to pull data from our database into the excel
sheet, just the chassis number, entry date and exit date. I would
like to paste this in my excel, and then be presented with the amount
of days a car was on the compound in each month.

Is there any way to this ? I know that if it was a full month, it's
easy to do, but let's say it has an entry on 13.01.06 and an exit on
20.10.06 , then it becomes more complicated. Also the calculation has
to be performed on several thousand cars at once...

Any help ??