Difference between dates

NLegresley

Unparseable

 

=COUNTIFS({Production Schedule Range 3}, IFERROR(MONTH(@cell), 0) = 1, {Production Schedule Range 2}, @Cell >=1)

 

Range 3 = Ship Date Column

Range 2 = Days Late colum that uses the formula =[Ship Date]@row - [Customer Req. Date]@row

Paul Newcome

Try changing @Cell to @cell (lower case "c").

NLegresley

That was it lol. Lowercase. 

Thanks

Paul Newcome

Happy to help. I have never tried an upper case "C" in an @cell reference, so I wasn't sure, but that was the only thing I could see that didn't fit.