If with And Formula help
I'm trying to write an If with And formula to flag if my micro/QC column contains a specific phrase, and my Date Submitted column is past its date by 12 days.
Here's what I have =IF(AND([Date Submitted]@row - TODAY() >= 12, [Micro/QC?]@row = "QC", 1, 0))
I'm getting incorrect argument set error and can't figure out what I'm missing.