Hi,
Need help with this formula, =COUNTIFS(C2:C1501,E2,G2:G1501,"<="&TODAY()+7)
I am trying to find CCM in "C" then check against today's date and check if any dates in "G" are in the next 7 seven days, it should return zero but returns 2 which are the two dates less than today's date.
Need help with this formula, =COUNTIFS(C2:C1501,E2,G2:G1501,"<="&TODAY()+7)
I am trying to find CCM in "C" then check against today's date and check if any dates in "G" are in the next 7 seven days, it should return zero but returns 2 which are the two dates less than today's date.