Count occurances where Deliveries were early or on time as compared to scheduled

Hello,

I am brand new to the forum and in need of help.

I have a set of data I need to count.
The data consists of 2 columns essentially, Scheduled Delivery Date and Actual Delivery Date.
If the Delivery was made on time or early, I want to count it. I will do a similar count for Late as well.
Additionally, the user can enter the Scheduled date range they want to count early/on time deliveries from. There all also blanks in the Actual Delivery date column where deliveries have not been made (no actual).

Cells O3:O38 contain the Actual dates
Cells N3:38 contain the Scheduled dates
Cell B3 contains the begin date to start the range.
Cell B4 contains the end date of the range.

I have tried using COUNTIFS and am having trouble getting the formula to work.

I tried:
=COUNTIFS(O3:O38,O3:38<=N3:38,N3:N38 ,>=$B$3,N3;N38<=$B$4)

I know this will not work but I hope it shows the logic I want.
Count range O3:O38 where values in O3:O38 are less than or equal to the corresponding cell value in N3:N38, for a range of N3:N38 that is greater than or equal to the date in B3 and less than or equal to the date in B4.

Thank you very much in advance for your help.

Thanks.
Adding a column may be an option but it is not preferred. We considered adding an Early/On time column and using and IF(O3<=N3, "Y",IF(O3>N3,"N","")) and then counting "Y"s by the restricted date range.
This would require creating a complete dummy worksheet since the data range set worksheet has ties to other users and adding columns to it is not an option.
I am hoping there is a way the ranges can be compared as arrays in the criteria argument section.

Attached is a sample spreadsheet.
The Early/On Time (Cell E12) and Late (Cell E13) are the ones I am trying to display count occurrences in.
the plan date range is A10:A27 and the Actual date range is B10:B27.
the date restriction range is set by inputting the Work Week number in Cell B2. Start date range is then B3 and end date range B4.
If shown how I am counting Plan and Actual occurrences, it is the addition of Early/On time and Late comparison of ranges that is giving me struggles
Early-On Time test.xlsx

Doh!
Try this:
Early-On Time test-r1.xlsx

that's not what I'm looking for though.
I need cells in B10:B27 compared to the corresponding values in cells A10:A27 for a range that is restricted to A10:A27 ">="B3 and "<=" B4.
Cell B18 is shaded red in the example not because it is greater than cell B4 but because it is greater than cell A18.
Cells B11, B15, B16, B17 and B19 are shaded blue because they are <= cells A11, A15, A16, A17 and A19.

the date range array is defined by cells in A10:A27 being >= B3 and <=B4. Those cells are shaded green. The countifs is counting cells in range B10:B27 that correspond the A10:A27 cells shaded green and comparing the B10:B27 value to the A10:A27 (Blue if <= and Red if >=)

I don't understand why you are comparing cell B10:B27 to cell B4 (B10:B27<=B4) in the equation above.
dates in cell range B10:B27 are considered Early/On Time if they are less or equal to the Plan date in Cells A10:A27 (and late if they are>)
Cells B3 and B4 are only used to define the range of Plan dates (Cells A10:A27) you want to look at.

That appears to be working! The last expression just needs to be reversed; it should be: --(B10:B27<=A10:A27)
I also added in the --(B10:B27<>"") so there are no inadvertant blank counts.

Thank you so much!