I copied and pasted an identical question regarding Excel. I tried following the solution in Numbers but I always get this error message "the operator "*" needs a number but it found 01/01/2020".
This is the formula I copied:
I basically need to know how many nights in a specific month were booked. If a guest arrived on Dec 27 and left on Jan 6 what can I do to have columns that say "December: 4", "January: 6" etc?
Thank you very much