I am currently using a formula array, kindly provided by Paul Sheppard, as
follows:-

{=SUM((Sheet1!$B$2:$B$9=Sheet2!A2)*(Sheet1!$C$2:$C $9<""))}

This array basically provides me with the number of entries with a specific
date in Column B and then how many actually include something other than no
issues in Column C from one sheet in a workbook and populates the appropriate
cell in another sheet in the same workbook.

As the 2nd sheet is only permitted to show 5 dates, albeit the 5th date of
each week (example below shows 16/9) is to include the Saturday and Sunday
dates (17&18/9) within it, could anyone help me in being able to adapt the
above array to encapsulate the additional Saturday and Sunday data under the
Friday data.

e.g. of 2nd sheet as below:

W/C 12/09 Total Loads Total Cases Failure Loads Failure Cases
12-Sep
13-Sep
14-Sep
15-Sep
16-Sep
TOTAL 0 0 0 0

Many thanks.

Ellie