Index & Collect Using Date Range

Kaykay

Hello,

I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work.

In a new sheet, I want to return the value of a specific cell from a different sheet based on the date range (3 months prior to today) field. This is what I tried and it doesn't seem to work. I'm also open to any other suggestions.

I tried (today)-90 but that didn't return any values

=INDEX(COLLECT({OSS Test Range 3}, {OSS Test Range 2}, <DATE(2022, 4, 1)), 1)

Jeff Reisman

@Kaykay Double check that the column you are referencing with {OSS Test Range 2} is really formatted as a date column. If it is actually a text/number column filled with date values, you cannot perform date calculations or comparisons against it.