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
Bookmarks