Any Excel Gurus? | ARRAY Function Help Needed

Sample Data Set.xlsx

See attached data set...

I have two OFFSET Named Ranges:

1. [Planned Activity End Date]
2. [Actual Activity End Date]

I am trying to achieve an output that demonstrates the Activity % OTC (On-Time Complete).

The Issue:

There can be many [Planned Activity End Dates] as independent line-items, however, there may only be one-for-one associated [Actual Activity End Dates].

This is because the [Actual Activity End Date] is only populated when an activity is completed. Currently my ARRAY formula is returning a % value that is including ALL
of the line items instead of only the one-for-one associated line items. In the sample data set, there are four [Planned Activity End Dates] and only two
[Actual Activity End Dates], one of which is > than the Planned End Date, the other is < than the Planned End Date. The actual output should be 50%.

No attachment.

Attachment below...

Sample Data Set.xlsx

Any Excel gurus out there I need your help.

=SUMPRODUCT((PlanEndDT>=ActEndDT) * ISNUMBER(ActEndDT) * ISNUMBER(PlanEndDT)) / COUNT(ActEndDT)

It need not be confirmed as an array formula.

You're welcome.