I am trying to count the number of dates that are greater than the corresponding date in the same row. I tried a COUNTIF but it is just looking if the date is great than any of the dates, so its not working. Here is the formula: =COUNTIFS( Date_Due_To_HQ,">"& Sent_By_Tertiary)
So if the date in Date_Due_To_HQ is greater than the corresponding date in Sent_By-Tertiary then I want it counted. Any help would be much appreciated!