COUNTIFS formula for any future date?
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.
Best Answer
-
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.
Answers
-
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 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 :).
-
@Jenna2424 take a look at this post, has a good explanation how to get around it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!