Issues in using IF & AND formula in counting room nights
I have a rooming list for an event in which I am trying to work out a formula below to count the number of rooms required per night, based on hotel check-in and check-out dates.
I tried the below formula to return with 1s.
=IF(AND([Hotel Check-in Date]@row <= [28/01/2023]$1, [Hotel Check-Out Date]@row > [28/01/2023]$1), 1, 0)
The above returns an error INVALID OPERATION
Help Article Resources
Check out the Formula Handbook template!