Formula for if within date range of a specific date

[hgrego]

Hi

I am new to Alteryx and I'm trying to figure out if there is a formula I can use to check if a date falls within a range of dates.

so if the dates in Date, Date 2, Date 3... are within the two week range from the date in "Date of action" then "No issue" 

Appreciate any help!

[KSowers]

There is a formula you can use in the Formula tool that does a DateTimeDifference Calculation for you and you can specify "days" as your unit. I attached an example of it in the workflow. If this works, please mark as solution. If not, let me know what else you need! Happy to help

[hgrego]

Hi

I have multiple date columns (more than 20) and I don't think creating new columns to compute the range for each column would work best. So i'm looking perhaps there is a way to check all the columns in one formula.

[KSowers]

How about something like this?

[flying008]

Hi, @hgrego 

If this like you want , please mark as solution, then it can help more people.