Forum Discussion
Solved
Adding date criteria to COUNTIFS
Hello. I'm trying to add a criteria to an existing COUNTIFS formula so that it will only return values if todays date is greater than a date in a cell. Existing formula is below =COUNTIF...
=COUNTIFS(Predicts!$E:$E,V3,Predicts!$A:$A,$V$4,Predicts!$F:$F,"Yes",Predicts!$G:$G,"<"&TODAY())You can try this formula if the date is in column G in sheet "Predicts".
=COUNTIFS(Predicts!$E:$E,V3,Predicts!$A:$A,$V$4,Predicts!$F:$F,"Yes",Predicts!$G:$G,"<"&TODAY())You can try this formula if the date is in column G in sheet "Predicts".
Worked perfectly, thank you 🙂