Countif using Dates and another Range
I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT reply. Not sure what is wrong. Below is a copy of my Formula.
=COUNTIF([Request Create Date]:[Request Create Date], >=DATE(2018, 1, 1), [Issue/Nonconformance]:[Issue/Nonconformance], "Install Vendor Workmanship")
Help Article Resources
Check out the Formula Handbook template!