Determine if a date is prior to another date/year - include as criterion


I would like to determine if a date is prior to 01/01/2015 and include it as criterion for the count/distinct/collect combination I inquired about previously??

=COUNT(DISTINCT(COLLECT({CIP Detail Summary Range 4}, {CIP Detail Summary Range 5}, ="OPEN", {CIP Detail Summary Range 3}, =0, IF(YEAR({CIP Detail Summary Range 1} < 2015)))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!