Hope you can help. Think i'm doing this correct but isn't working i think because of dates.
My table is A2 to P5000. I was using =COUNTIFS(E:E,T3,P:P,1)
Column E:E is dates during the year, Column P:P is number of days which is a calculation between order recieve and order due. T3 is...