Hi
I have been trying to solve this for 2 days now without the luck.
I need to count "With QC - Trade" within last 30 days, then there will be other within 60 days, 90 days etc, but I need to sort out 30 days first.
I got this formula, data and calculation are on different tabs:
=COUNTIFS('Corporate Master'!F:F,"With QC - TRADE",'Corporate Master'!I:I,"<="&(NOW()-30))
So when I selected the data manualy, I got 11, and the formula counted 9, wham am I doing wrong?
I have been trying to solve this for 2 days now without the luck.
I need to count "With QC - Trade" within last 30 days, then there will be other within 60 days, 90 days etc, but I need to sort out 30 days first.
I got this formula, data and calculation are on different tabs:
=COUNTIFS('Corporate Master'!F:F,"With QC - TRADE",'Corporate Master'!I:I,"<="&(NOW()-30))
So when I selected the data manualy, I got 11, and the formula counted 9, wham am I doing wrong?