Late count based on number of days between two dates for a list of dates

I have an index row above a row of dates.

A1:E1 = 1,2,3,4,5
A2:E2 = 1/3/17,1/10/17,1/19/17,1/25/17,2/3/17

I need to get a late count of how many times there are >8 days between 2 dates.

Is there a way to format the below formula into an array to test all dates?

if(datedif(a2,b2,"D")>8,TRUE,FALSE)


My thought process was to insert that function into a count function that counts the number of times this is true:

countif(if(datedif(a2,b2,"D")>8,TRUE,FALSE),TRUE)


However, I do not how to format this to operate on an array. I tried the below formula, but it did not work.

countif(if(datedif(a2:d2,b2:e2,"D")>8,TRUE,FALSE),TRUE) CTRL+SHIFT+ENTER



Any ideas on how to get this accomplished? Thanks.

Hi there,

As only five date cells are involved, you could try putting the following formula in Cell F2:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M