Count # of cells approaching a date for sheet summary
I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell.
This is what I've tried:
=COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7)
Thank you for any help!
Best Answer
-
@rbattista Got it. This works on my sheet.
=COUNTIFS([Start Date]:[Start Date], >=TODAY(), [Start Date]:[Start Date], @cell <= TODAY() + 7)
Isis Taylor
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
Answers
-
@rbattista Try it this way.
=COUNTIF([Off-Site to On-Site Return Estimation]:[Off-Site to On-Site Return Estimation], (@cell > TODAY (-7)))
Isis Taylor
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
-
@Isis Taylor, still Unparsable, weird!
-
Are you trying to determine if the date within the off-site cell is less than a week from the current date (Today's Date)?
Isis Taylor
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
-
@Isis Taylor I'm trying to determine if the date in the cell is 7 days away, so in a way, yes! I just need to count the number of cells that have a date that is approaching.
-
@rbattista Got it. This works on my sheet.
=COUNTIFS([Start Date]:[Start Date], >=TODAY(), [Start Date]:[Start Date], @cell <= TODAY() + 7)
Isis Taylor
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
-
@Isis Taylor, that worked for me too! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!