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

Aoife M

Hi,

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.

Paul Newcome

Try this:

=COUNTIFS([Target Closure Date]:[Target Closure Date], AND(@cell >= TODAY(), @cell <= TODAY(180)))

Paul Newcome

Try this:

=COUNTIFS([Target Closure Date]:[Target Closure Date], AND(@cell >= TODAY(), @cell <= TODAY(180)))