can anyone help me solve the error I get when I enter the below given
Any help is much appreciated.
first of all, thanks for your efforts in
trying to find a solution !
When I use the formula though, it comes up with an error. See hxxp://
members.home.nl/hoenb/SNAG-0024.jpg for details on the error.
Many thanks in advance for your tip on solving the
On 30 jan, 17:12, "Bernie Deitrick" wrote:
- Tekst uit oorspronkelijk bericht
niet weergeven -
- Tekst uit oorspronkelijk bericht weergeven -
> 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 HTH,
> MS Excel MVP
> "Bart" > wrote in message
> > 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
> > 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
> > 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 ??