Check box IF date in a list

Julie Barbeau

Hi,

I'm trying to figure out how to create a column that has a checkbox when a date in one cell is one of a list of dates in another sheet but it doesn't seem to work. See below, 21-11-15 should be checked as this date is in my list. Here is the formula I use : =IF(CONTAINS([End date]@row; {Férié Plage 1}); 1; 0)

NocturnalAnimal

are both your columns formatted as Date columns? They would need to be Text/Number columns for the formula to check the boxes.

NocturnalAnimal

are both your columns formatted as Date columns? They would need to be Text/Number columns for the formula to check the boxes.