Using contains for a date in a range of dates
I would like to check if a certian date appears in a range of dates. I tried contains function but it only works for string/int type.
attaching a screenshot:
I would like to check if 8/12/22 (CF col) is in holiday col, and if it is, then take CF date and minus 2.
I tried this formula:
=IF(CONTAINS(CF@row, holiday:holiday), CF@row - 2, CF@row)
but it won't work
is there any way to to that?
Help Article Resources
Check out the Formula Handbook template!