Categories
User Help

In Apple Numbers what formula can calculate the amount of days in a certain month across 2 dates

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:

=NOT(OR(D$1>$B2,EOMONTH(D$1,0)<$A2))*(MIN(EOMONTH(D$1,0)+1,$B2)-MAX(D$1,$A2))

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

Leave a Reply

Your email address will not be published. Required fields are marked *