If two criteria place in third criteria column

I'd like to add almost the same portion as the panel onto the Group.

For example: If any part of [Group] says "Group A" AND any part of [Panel] says "sub-group aa" AND the [Day Off] says "Yes" then find the date in the [Day of the Month] and place 0.75, if not place a 1.

The formula Bo_Ry created was perfect, however, I just need to add the AND [Group] portion.

I've attached the version 2 workbook and highlighted what needs to be accounted for in Green. I really appreciate all the help everyone!