Count if older than

Trying to count the number of dates that are older than "Todays" date by 14 days.
So if today is 4.16.21, anything that was listed in my date column that is 14 days older than 4.16.21 would be counted.
Example: Date Colum has 2 rows filled out.
Row1 - has a date of 4.16.21
Row2 - has a date of 4.1.21
The formula cell would produce 1.
**I need the date to always look at the actual date of the document.**
In excel I used the following formula. =COUNTIF(Range,"<"&TODAY()-14)
Additionally, I will need to take that formula and add another condition to it. So is it older than 14 days from "todays date" -AND- is it listed as "Active" in another column.
In excel I accomplished this with the following formula: =COUNTIFS(Range,"<"&TODAY()-14, Range,"Active")
Thanks.
Best Answer
-
Thanks!!
I was able to get it to work with the following:
=COUNTIFS(Range:Range, <TODAY(-14))
Answers
-
If I'm understanding the scenario, I believe this should work for you.
Today's Date: Set as Date
Date: Has your list of dates [Also set as date]
Column4: =COUNTIFS(Date1:Date5, <TODAY(-14), Status1:Status5, "Active")
Status: Has your "Active" status.
Hope that helps!
-
Thanks!!
I was able to get it to work with the following:
=COUNTIFS(Range:Range, <TODAY(-14))
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!