Good day, I am using the formula below but getting unparseable error.

Brent Bowser

=COUNTIFS(Year:Year, = YEAR(TODAY()), [Month Issued]:[Month Issued], = MONTH(TODAY()),([Due Date Forecast]:[Due Date Forecast], >0)))

Heather Duff

Hi @Brent Bowser ,

It looks like you have an extra end parenthesis. Try removing the last end parenthesis and see if that fixes it.

Best,

Heather

Leibel S

@Brent Bowser

Below is your formula fixed:

=COUNTIFS(Year:Year, @cell = YEAR(TODAY()), [Month Issued]:[Month Issued], @cell = MONTH(TODAY()), [Due Date Forecast]:[Due Date Forecast], @cell > 0)