COUNTIFS if a Date cell is within 30 Days
Hi,
Is it possible to COUNTIFS with one of the criteria being a date that is equal to or within 30 days to that set in another cell?
In the past I have used a helper column to count the days and just count the cells that fell within the number of day <=30, <60, etc.
Any help would be much appreciated.
Thanks
Richard
Best Answers
-
So something like this? I am counting the number of entries that are <= 30 days from the value in Date 2 using the formula below
=COUNTIF(Date:Date, @cell <= [Date 2]1 + 30)
-
Please try below formula.
=COUNTIF([Past Due]:[Past Due], AND(@cell <= TODAY(), @cell > TODAY(-30)))
=COUNTIF([Past Due]:[Past Due], AND(@cell <= TODAY(), @cell > TODAY(-60)))
-
Hi Kimberley & Prasad,
Many thanks for the reply, both works.
Richard
Answers
-
So something like this? I am counting the number of entries that are <= 30 days from the value in Date 2 using the formula below
=COUNTIF(Date:Date, @cell <= [Date 2]1 + 30)
-
Please try below formula.
=COUNTIF([Past Due]:[Past Due], AND(@cell <= TODAY(), @cell > TODAY(-30)))
=COUNTIF([Past Due]:[Past Due], AND(@cell <= TODAY(), @cell > TODAY(-60)))
-
Hi Kimberley & Prasad,
Many thanks for the reply, both works.
Richard
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!