Need a suggestion for an fx

[MikeyZ]

I have dates in Col F and G.
In F1 I need to arrive at a number showing which ones are on time
and in F2 I need a count on how many are late.
Col F4:F1000 is the ship date from the customer
Col G4:G1000 is the required due date.

 

[FormR]

Hi, something like this maybe?

Excel 2013/2016
	E	F	G
1	On Time:	1
2	Late:	2
3		Ship Date	Due Date
4		01-Jan-17	01-Jan-17
5		01-Jan-17	02-Jan-17
6		31-Dec-16	01-Jan-17
Sheet2

Cell Formulas
Range	Formula
F1	=SUMPRODUCT(--($F$4:$F$1000>=$G$4:$G$1000),--ISNUMBER($F$4:$F$1000))
F2	=SUMPRODUCT(--($F$4:$F$1000<$G$4:$G$1000),--ISNUMBER($F$4:$F$1000))