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 […]