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