Please i need to edit this formula to display guest name in booked calendar in (availability) =IF(AND($B8<>"",$C8<>""),1-SUMPRODUCT(('Room Reservation'!$F$2:$F$1000 =E$7+1)*('Room Reservation'!$J$2:$J$1000=$B8)*('Room Reservation'!$K$2:$K$1000=$C8)),"") and i need a formula to look about guests between two dates in (sheet1)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

I need help please

Thread starter Tameima
Start date Mar 13, 2022
Tags

excel

Tameima

New Member

Mar 13, 2022

Please i need to edit this formula to display guest name in booked calendar in (availability)
=IF(AND($B8<>"",$C8<>""),1-SUMPRODUCT(('Room Reservation'!$F$2:$F$1000<=E$7)*('Room Reservation'!$G$2:$G$1000>=E$7+1)*('Room Reservation'!$J$2:$J$1000=$B8)*('Room Reservation'!$K$2:$K$1000=$C8)),"")

and i need a formula to look about guests between two dates in (sheet1)