Counting a row if due date is >= 2 weeks from TODAY()

Camie Keuck

Hi All

I was wondering if anyone has been able to come up with a formula to count a row if the column due date is a certain amount of days from "today". I want to add a backlog tracker to my dashboard but I can't seem to come up with a solution that works. Below is the formula I came up with but it obviously has failed me.

=COUNTIFS({AR Need By}, TODAY() > 15)

Any help is greatly appreciated - thank you!

Chris Walker

Hi Camie,

There may be some other ways to do this, but here is something to try. I've found there are some unique aspects of placement of greater than and less than signs around the today condition.

=COUNTIFS({AR Need By}, >TODAY(), {AR Need By}, <TODAY(15))

Hope this helps

Chris Walker

Hi Camie,

There may be some other ways to do this, but here is something to try. I've found there are some unique aspects of placement of greater than and less than signs around the today condition.

=COUNTIFS({AR Need By}, >TODAY(), {AR Need By}, <TODAY(15))

Hope this helps