Excel Countif Date in column A is greater than column B

excel date countif
spassen picture spassen · Dec 26, 2012 · Viewed 37k times · Source

Columns A and B both have dates. If the date in column A is greater than the date in the same row of column B, the row should be counted. To add context, I am trying to count the number of rows where the completion date is past the due date. How can this be accomplished?

Thanks.

Answer

RocketDonkey picture RocketDonkey · Dec 26, 2012

You can try this:

=SUMPRODUCT(--(A:A>B:B))

It will sum all instances in the range where the date in column A is greater than that in column B.

You can also do this, however it needs to be entered as an array formula (Ctrl+Shift+Enter):

=SUM(IF(A:A>B:B,1,0))

Related questions

Excel VBA Countif between dates

I am needing to create a function to count the occurrences of an account number between two dates. The first date is based on the function input and the second is 3 months in advance (date may not be contained within …

Read More
Count number of times a date occurs and make a graph out of it

I have a list of dates, each date in it can occur more than once. I want to count the number of times each date occurs (histogram) and display it in a graph (with the Y axis being the number …

Read More
Formula to convert date to number

I would like to know the formula to convert a date in 10/26/2013 to 41573 number as done in Excel. Like how 10/26/2013 is converted to 41573.

Read More