Hi Everyone,
I am trying to create a booking tracker, for example if I input start and end date per guest/room, this days will be highlighted on calendar. One room can have different guest on different dates range.
I was using if(and(vlookup, but only able to have first guest info on the calendar, how to have 2nd guest info (different dates) mark on the calendar as well.
Anybody knows?
Many Thanks!
I am trying to create a booking tracker, for example if I input start and end date per guest/room, this days will be highlighted on calendar. One room can have different guest on different dates range.
I was using if(and(vlookup, but only able to have first guest info on the calendar, how to have 2nd guest info (different dates) mark on the calendar as well.
Anybody knows?
Many Thanks!