Average Work days

[poikl]

Hi, could you please help me with my Driving Expense worksheet?
In Col C I entter the Date of Gas Fill-up. In colD I'd like it to show the Days between Fill-ups (Subtract Row2 from Row3 on ColC) and on the TOTAL Row (Row 300) I'd like it to show the Average "WORK" Days between fill-ups. Thank you

 

[scottylad2]

you would need to add another column and use Networkdays, then average that on your totals row

Excel Workbook
	B	C	D	E
1	Start	01/01/2011	Between Fills	Work Days
2		15/01/2011	14	10
3		24/01/2011	9	6
4		30/01/2011	6	5
5		06/02/2011	7	5
6		20/02/2011	14	10
7		01/03/2011	9	7
8		15/03/2011	14	11
9		24/03/2011	9	8
10		07/04/2011	14	11
11		14/04/2011	7	6
12		19/04/2011	5	4
13		28/04/2011	9	8
14		05/05/2011	7	6
15		14/05/2011	9	7
16		27/05/2011	13	10
17		09/06/2011	13	10
18		14/06/2011	5	4
19		23/06/2011	9	8
20		01/07/2011	8	7
21		15/07/2011	14	11
22		24/07/2011	9	6
23		31/07/2011	7	5
24		12/08/2011	12	10
25			9.695652174	7.608695652
Sheet1

Column C is showing days between fills and averaged in the bottom row,Col D is showing workdays between fills, and is averaged at the bottom

 

[poikl]

Thank you Scot, Could you also Please provide formula for Col "D" (to subtract one date from the other)

 

[scottylad2]

Thank you Scot, Could you also Please provide formula for Col "D" (to subtract one date from the other)

sorry, not sure what you mean by this. Column D is already subtracting dates via the Networkdays function, it's subtracting the workdays between fill ups.

can you elaborate in what you mean?

 

[poikl]

Sorry to bother you Scot, My Mistake. I forgot to Format CoC to "General" and it wasn't giving a readable result.