Formula for # of Room Nights omitting false data
I have this formula in excel that I am trying to recreate in SmartSheet:
Criteria is Check-In Date and Check-Out Date. The $D$1 is 12/31/9999 which I want to count as 1 night. When that date appears it is in both columns so it produces an Invalid Operation.
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
Help Article Resources
Check out the Formula Handbook template!