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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!