Sum value if between or on a start / end date

[ryan_law2000]

I have in a table 3 fields a Start Date / End Date / # of Equipment (Columns A,B,C)
I want to be able to look at the month and see the sum of the required # of equipment.
The issue is the number of equipment is being used everyday from start to end date.
So quick example:
Nov 1 / Nov 5 / 5
Nov 4 / Nov 10 / 10
Nov 1 / Nov 9 / 15
If I want to see total equipment for Nov 2 it would be 20, Nov 4 = 30, Nov 10 = 10. So it would sum even the dates in between.

Option 1:
Can this be done directly in a pivot table at all with a formula?

Option 2:
Create a separate table with every date in 1 column and # of equipment in another.
Then create a formula that is able to sum for each day separately. (then create pivot table from this)
I cannot figure out what this formula would be though, any ideas?

 

[Chrisdontm]

This may get you down the road...
First might I say that it is better to change the name of the header " # of Equipment " because the pivot table doesn't seem to like the odd character in the formula.

So calling that column: Equipment No.
And as for the name of the table: Table1
Then which ever date you want to look up, enter it into F1
Let's say this formula goes in G1:

=SUMIFS(Table1[Equipment No.],Table1[Start Date],"<="&$F$1,Table1[End Date],">="&$F$1)

You may have to adjust the formula for your table...