excelBean25
New Member
- Joined
- Mar 25, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Ok. I've usually been good about googling for solutions, but I can't figure out the following problem.
I have a range of values, in this case historical dates, and I'd like to count those values that are a certain distance from a constant value (today's date or a future date).
For example, I have the following dates in a column: 3/31/2013, 1/30/2019, 12/19/2017
In another cell, I have a date in the future from those above, say 3/25/2021.
I'd like to calculate in one cell the number of data points in the column of dates that are greater than 1000 days but less than 2000 days in the past from the future date. In this case it would be one data point.
I've googled solutions with COUNTIFS but it doesn't seem to work when subtracting a range of numbers from a single number as I'm trying to do above. This will apply to columns with hundreds of data points.
I have a range of values, in this case historical dates, and I'd like to count those values that are a certain distance from a constant value (today's date or a future date).
For example, I have the following dates in a column: 3/31/2013, 1/30/2019, 12/19/2017
In another cell, I have a date in the future from those above, say 3/25/2021.
I'd like to calculate in one cell the number of data points in the column of dates that are greater than 1000 days but less than 2000 days in the past from the future date. In this case it would be one data point.
I've googled solutions with COUNTIFS but it doesn't seem to work when subtracting a range of numbers from a single number as I'm trying to do above. This will apply to columns with hundreds of data points.