Count a specific date within a range of multiple dates

[Confused twice]

Hi,
I'm struggling with working the code that will enable me to count the number of times a specific date falls between ranges of multiple dates. I'm trying to automate a system to allow me to see how many people are at work on any given day of the month by knowing when they are on rotation.
E.g.
Mr M Smith is at work 22nd Oct 2015 until 20th Nov 2015 so need to show as a number that he is at work on 23rd Oct 2015.
Miss S White is at work 29th Oct 2015 until 30th Nov 2015 so need to show as a number if she is at work on 28th Oct 2015
Etc.
I've attached the spreadsheet I'm working with. I've only been able to show "FALSE" or "YES"/"NO" for the adjacent dates not the whole range in columns C and D. I’d like the result to show a number i.e. 10 or 20 people are at work on 28th Oct 2015 etc.

Any help would be much appreciated.
Thanks

[shukla.ankur281190]

Try
B2=COUNTIFS($C$2:$C$152,">="&A2,$C$2:$C$152,"<="&A2)+COUNTIFS($D$2:$D$152,">="&A2,$D$2:$D$152,"<="&A2)

May be this will help.

[Confused twice]

Thanks Ankur, but it's not working. A random date of 15th Oct 2015 is showing 9 but using conditional formatting it shows there are 28 entries that meet that criteria. I've updated the spreadsheet to show that.
Regards

[shukla.ankur281190]

Sorry I am unable to understand what you actually want, however Try =COUNTIFS($C$2:$C$152,">="&A2)+COUNTIFS($D$2:$D$152,"<="&A2)

Please Login or Register  to view this content.

If it not what you looking for, please mention desired result once

[samba_ravi]

b2=COUNTIFS($C$2:$C$152,"<="&A2,$D$2:$D$152,">="&A2)

Please Login or Register  to view this content.

Try this and copy towards down

[Confused twice]

Shukla, Siva,
This works brilliantly; thank you so much for your help.
Really appreciated.
Regards
Marcus

[Confused twice]

Folks, the help you gave was invaluable but I'd like to ask one more question if I may. Is it possible to insert the names of the people who are "Working" on a given day in a separate column based on the day you open the file? Or at least highlight the names?