Multiple COUNTIFS formula but getting the wrong output

Hi All, i am trying to computerize a staffing rota. I have completed a COUNTIF formuala for the individual days total. I am now trying to make another tab so it calculates the amount of shift per individual for the month.

The original formula for the individual days total is :-

=SUM(COUNTIFS(F2:F50,{"D","DLTV","0700 - 1300","0700 - 1500","0700 - 1700"}))

This gives me the correct number of Early shifts for all staffing members for Monday 17 September.

The problem happens now I'm doing the individual per month. I have tried the formula:-

=SUM(COUNTIFS(Registered!F9:GG9,{"D","DLTV","0700 - 1300","0700 - 1500","0700 - 1700"},Registered!$F$1:$GG$1,{">=01/09/2018","<=31/09/2018"}))


I do not get an error message but get a value which, when i check by counting individually is not right.

The date format i am using is a custom date:-

ddd - dd - mmm - yy (Mon - 17 - Sep - 18)

However when typing in the cell i use standard UK format eg. 17/09/18. I'm not sure if this is causing an issue. I have tried to be as thorough as i can above but let me know if you need more info.

Help would be much appreciated!

Thank you WBD worked a treat!

I was working on October when i was copying this formula hence the 31 days but well spotted

Frustrating bit is i tried this but didn't know about the & before the date and the >= had to be in there own parentheses.

Oh well Lesson Learned!

Much appreciated again!