Countifs with an IF statement and dates
Hi, I have two dates in my sheet - a final filing date and an extended final filing date - I am trying to identify the number of advertisements that are closed (for clean ads)- I can count with this countifs statement the FFD but don't know how to factor in the extended final filing date when that field contains a date (is., is not blank).
=COUNTIFS([CLEAN POSITION]:[CLEAN POSITION], 1, [FINAL FILING DATE]:[FINAL FILING DATE], <TODAY(-1), [APPLICANT/CANDIDATE NAME]:[APPLICANT/CANDIDATE NAME], "ADVERTISEMENT")
Any help would be greatly appreciated!
Thank you all!
Help Article Resources
Check out the Formula Handbook template!