Less than or equal to 30 days from today
Hello,
I'm trying to figure out how to finalize this formula to be correct but I'm having issues. I want it to count if the date from another sheet is less than or equal to 30 days from today. However its counting dates prior today. I feel like its something simple im missing but just need some help. See formula below.
=COUNTIF({Field Operations Proposals Range 2}, <=DATEONLY(TODAY(30)))
Answers
-
You can use this formula
=COUNTIF({Field Operations Proposals Range 2}, <=TODAY(30))
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Aravind,
Thank you for your response. I have tried that one as well and get the same result as the one i posted originally. I've tried several other variations as well and got a similar result.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 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!