validate if value indexed between 2 array of dates

[Afarag]

Dears,

please i need help as i have a values column called "Call Date" need to verify if this column indexed in the array of Date columns "Time from()" and "time to"

i need if the call date Value indexed between the dates array put a string "Valid" into "Validation" column
gratefully

 

[Awesome Wally]

Afarag, You can put the following into your Validation column: =IF(SUMPRODUCT(--([@[Time From ()]]<=[@[Call Date]])*--([@[Time to ()]]>=[@[Call Date]])),"Valid","").

FYI: None of your data in the Call Date Column is between the corresponding Time From () or Time To ().