If Column 1 Or Column 2 have dates outside Range then "{Column(s) outside range"

[wonka1234]

Hi,

How do I create a formula that identifys each column that have dates outside a certain range.

Ie if my range is Nov 1 2022 to Dec 1 2023, how can I check each column I choose and let me know if it contained within?

something like this:

If Contains([Date1] or [Date2], BETWEEN Nov 1 2022 and Dec 1 2023) Then "Date Column 1 / Date column 2 OR BOTH " else "" Endif

[ShankerV]

Hi @wonka1234 

Can you please explain your question with an input and the expected output.

Will be easy to fetch the output based on your expectation.

Many thanks

Shanker V

[DataNath · Accepted solution]

Hey @wonka1234, how's this? Will flag the column(s) that are in the range: