Working out headcount of staff via two cells with start and end date to show weekly headco

Hi,

New to forum...have looked for ages but never got that badly stuck on Excel that I have had to post....this all changed today!

I need to create a weekly headcount of staff based on data in the format.

Start of contract in column D
End of contract in column E

Date format is in e.g. 19/10/2013...I need this to show as a total headcount of staff by week running from May to October (obviously changing as to the start and end dates). I have tried a few countifs etc but to no avail.

Would be great if someone could help as I'm panicking now as its for a big report on Monday.

Thanks

James

Hi,

I have added an attachment. its to give a headcount total...not just a starters and leavers number this is what is confusing me as well.

I have added on the second tab a mini example of what it'll look like when the formula is correct (or what i'd want it to be represent).

Also some of the column end dates are blank due to an on going contract.

Cheers James