COUNTIFS formula for any future date?

Jenna2424

Hi all,

I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date.

I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working.

Any advice would be appreciated! Thank you.

Samuel Mueller

try this =COUNTIFS({due date column's range}, @cell>=TODAY())

Also, keep in mind that the today formula does not update unless the sheet is opened and saved everyday. There are some workarounds to this issue.

Samuel Mueller

try this =COUNTIFS({due date column's range}, @cell>=TODAY())

Also, keep in mind that the today formula does not update unless the sheet is opened and saved everyday. There are some workarounds to this issue.

Jenna2424

@Samuel Mueller Wow, thank you so much for the quick response! It looks like that formula worked!

That is a good tip to know. What are those workarounds? The sheet is usually used and saved daily, but in case of holidays, would the formula stop working?

Thank you again :).

Samuel Mueller

@Jenna2424 take a look at this post, has a good explanation how to get around it.

https://community.smartsheet.com/discussion/99643/new-help-article-automatically-update-the-today-function-in-formulas