I am trying to create a COUNTIF formula that counts the number of rows where the date is 100 >

Abbie G

TODAY-date.

It doesn't seem to count all the rows where the date has more than 100 days. This is the current formula I have right now

=COUNTIFS({role}, "abbie", {PRJT}, $[Project Type]@row, {date}, @cell > (TODAY(100)))

David Tutwiler

I'm not totally sure what it is you're trying to do, but it might be helpful to describe what your current formula is doing. Once you get to the {date} group, you are checking that the date in the row is greater than TODAY + 100 days. So you're essentially checking to see if the date in the cell is more than 100 days away.

Is that what you were trying to do?