This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi there, help needed!
I have an arrival and a departure date, different dates over a 2 week period, I then need 14 columns with if/then formulas so I can get a room count for each specific night. In Excel I had =if(departure=>[date],"-",if(arrival=<...
That’s fab thanks, yes, I did the quick and dirty the wrong way round!! So, I can then generate the daily tallies and filter and list, but I cannot see how to get a room count totalling them - the sum appears at the top of the column but cannot see h...
