how to calculate days worked for an average over a five week period

Could someone please tell me how to calculate days worked. So basically you can see from the attached spreadsheet that over a 5 week period I record start times and finish times. On the Overall section I have a box stating how many hours have been wored in toal but want to divide that by the days worked, as obviously I don't want it divided by say 31 days, I want the actual days worked. Thanks in advanceMega master.xlsx

Hi, maybe (in E5):
=IFERROR(D5/(COUNTIF(Week1!C10:I10,">"&0)+COUNTIF(Week2!C10:I10,">"&0)+COUNTIF(Week3!C10:I10,">"&0)+COUNTIF(Week4!C10:I10,">"&0)+COUNTIF(Week5!C10:I10,">"&0)),0)

Hi shouldn't be a problem. For counting nights out, change to COUNTIF(Week1!C11:I11,"Y")+COUNTIF(Week2!C11:I11,"Y") etc.

Thank you so much for that. Can I be cheeky and ask another question? On some occasions drivers may drive different vehicles. so for example on Week 1 if a driver drives truck A, then the following day drives truck B, on the Trucks Overall page, I need results for each truck, how do I get it to know that the driver had driven a different truck, and to make sure the correct information goes into the correct column in the Truck Overall page? Sorry for this, as you can tell I'm not very good at this Mega master.xlsx Attached is the updated file

Wow, that one has gone right over my head. Could you place them in the spread sheet that was attached to show me what you mean instead?