Column A:A and B:B consist of dates (mm/dd/yyyy) and are both dynamic offset named ranges. Column A:A is the "Planned End Date" and column B:B is the "Actual End Date". I want to count the number of instances where the date in B:B is greater than the date in A:A on the same row, then divide by the total number of rows consisting of a date in column B:B. I write Array functions from my data set because it is in SQL table format residing in Excel, and since my End Users submit new row data on a daily basis using a VB data entry UserForm, the named ranges of each column must be dynamic, thus I offset them to grow with each additional. row of data added.

The output I'm looking for will be a percentage yield.

Any help is greatly appreciated.