CountIfs for One Date Greater Than Another Within a Given Period

rfhickey
rfhickey ✭✭
edited 12/09/19 in Smartsheet Basics

Hi there!

I'm trying to get a total of projects projected to start between two dates that actually started after their projected start date. This is the formula that I have so far:

=COUNTIFS({Design Document Projected Start Date}, >=DATE(2019, 4, 1), {Design Document Projected Start Date}, <=DATE(2019, 6, 30), {Design Document Actual Start Date}, >{Design Document Projected Start Date})

I am able to get the correct number of projects that started between April 1 and June 30 (the first part of the formula), but when I add the second part of the formula (after 2019, 6, 30), I get 0 and I should be getting 3.

Any thoughts?

Comments