COUNTIFS for Projects Completed Within Past 90 Days

04/09/19 Edited 12/09/19

For some reason I can't get this formula to work. I get 0 every time. Using a filter, I can see that number is incorrect. I want to count how many "Course" projects, per organization have hit complete in the past 90 days.


=COUNTIFS({Project Type}, "Course", {Organization}, [email protected], {Completed Date}, <=TODAY(-90))



  • Paul NewcomePaul Newcome ✭✭✭✭✭

    For the past 90 days, you would need >= instead of <=.

  • I checked that against a filter that I ran on the source sheet. when I use <=TODAY() and then close with >=(-90) I get the matching result to that of the filter. When I remove <=TODAY() and only leave >=(-90) I get a totally different number than what the filter shows.

    I am wondering where the discrepancy is.

Sign In or Register to comment.