Create a new column based on conditions

Fuzzyjoin package Tidy way to range join tables, on an interval of dates