How to use IF function to compare two dates and tick checkbox
I would like to use a IF function that test that when the date that the user input in a form in the Form sheet is the same is the date listed in the "Availability" sheet, it must tick the checkbox.
I am currently using this formula but get a "INVALID OPERATION" error. Both columns are 'Date' type.
The objective is to use it as a booking form where a report will show which dates are still available to be booked (the unchecked rows)
Help Article Resources
Check out the Formula Handbook template!