FILTERING DATA USING A START AND END DATE

[tomtingley]

Hi all,

I've asked something similar before but looking for a solution to the below:

Using the attached data, I'm trying to create an output which will flag any data that is showing outside the 'Start Date' and 'Exit Date'.

For example, the first few rows show a Start Date of 20th December 2023 and an Exit Date of 19th December 3009. Therefore, I would want to flag any data that is showing before December 2023 and after 3009 (in this case won't matter as date is too far in the future).

Another example, if the data showed a Start Date of 1st January 2024 and an Exit Date of 1st January 2026, I would want to flag any data before Jan 2024 and after Jan 2026.

Hope this makes sense.

Thanks,

Tom

[BS_THE_ANALYST]

@tomtingley potentially this is what you're looking for?

It returns blank values to flag where values fall outside the range:

[binuacs]

@tomtingley One way of doing this