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.
Bookmarks