Finding number of days between dates and categorising by week ending date

Days leave by week ending date v2.xlsx

Anyone able to correct the formula in here? It seems to work except for in cell H4 where it reports 3 days instead of 1

This is the number of working days (Mon-Fri) between the dates in columns A - B
Days as above split by week ending dates (Sundays), row 3
Days as above within the range specified, date ranges in rows 1-2

Formula is cell E7, all others manually populated to show what I want the answer to be

Thankyou

Originally Posted by shukla.ankur281190

try

D4=SUMPRODUCT(--ISNUMBER(MATCH(ROW(INDIRECT(D$1&":"&D$2-2)),ROW(INDIRECT($A4&":"&$B4)),0))) and drag over the cells and down.

Same outcome as {=COUNT(MATCH(ROW(INDIRECT(D$1&":"&D$2-2)),ROW(INDIRECT($A4&":"&$B4)),0))}

Where in cell H4 it shows 3 days are between the 29th Feb & 29th Feb for week ending 6th March. This should just be one day

Thinking about this I just need to change the minus two to work out how many weekend days are between the date ranges, solved my own problem

D4 = {=COUNT(MATCH(ROW(INDIRECT(D$1&":"&D$2-((DAYS(D$2,D$1)+1)-NETWORKDAYS(D$1,D$2,$L$2:$L$16)))),ROW(INDIRECT($A4&":"&$B4)),0))}