Counting the number of items due in the next six months from today's date



I am struggling to find a formula that can count the number of items (each row represents a task/project) that are due in the next six months from TODAY (the date of viewing). At the moment the below formula is incorrect ...

=COUNTIF([Target Closure Date]:[Target Closure Date], IFERROR(MONTH(@cell), TODAY(MONTH(+6))))

Other info: This formula is being used in the sheet summary section and to be displayed on dashboard as metric. The column "Target Closure Date" contains the target end dates, some of these may be blank.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!