I have some Data where, there are 8 columns. I want to keep Column, B,E,F,G,H and I.

In Column B I have Some positions and in other columns E,F,G,H and I i have dates. I want to convert the dates as 1 to count the Roles, to know that how many times the date is repeated in "Headers" for the "Roles".

I have created Manually the Result Data. I have large set of data and it takes my multiple days to achieve this result.

I would really appreciate the help if it can be achieved using formula.

DATA

RESULT