Count Expired Dates

[Mcook13]

I am trying to count how many dates have expired in a range of cells.

I have in column Q cells with due dates for the customer's orders.

In column R I have the dates of when their order will ship.

I want to count how many dates are past the customer's due date.

The formula I currently have is =COUNTIF(R10:R130,">="&Q10:Q130), but returns a 0 value and I can't figure out how to write it.

Can anyone help?

 

[kweaver]

Don't you just want the difference?

6/1/2019	6/5/2019	4
6/12/2019	6/12/2019	0
6/15/2019	6/16/2019	1

<colgroup><col span="3"></colgroup><tbody>
</tbody>

Which is R10-Q10, etc.

 

[Mcook13]

No. I'm looking to count the total number of orders whose dates will be ship after the customer's requested order due date.

I can format that to display in a percentage.