Hi - I'm trying to put together a bookings calendar which is working out okay apart from when I get to a change over day when ideally I need two names against a particular date - the name of the person leaving and the name of the person coming in.
I have two worksheets - one named "Bookings" and the other named "Calendar". In Bookings I have Column A as Date from, Column B Date to and Column C the persons name plus various other columns that are not relevant to this query. The Calendar worksheet is just a basic year to view split into 52 x 7 day rows with a blank row in between. The blank rows are filled with the following formula =IFERROR(INDEX(Bookings!$C$2:$C$200,MATCH(1,(Bookings!$A$2:$A$200<=A1)*(Bookings!$B$2:$B$200>=A1),0)),"")
In the Bookings worksheet I have something like this
1/1/18 8/1/18 John
8/1/18 15/1/18 Jim
15/1/18 22/1/18 Jill
My problem is with the 8/1/18 and 15/1/18 in that I really need to see John/Jim for the 8th and Jim/Jill for the 15th. At present I only get John for the 8th and Jim for the 15th.
If anyone had any suggestions how I might achieve this, I would be very grateful!
I have two worksheets - one named "Bookings" and the other named "Calendar". In Bookings I have Column A as Date from, Column B Date to and Column C the persons name plus various other columns that are not relevant to this query. The Calendar worksheet is just a basic year to view split into 52 x 7 day rows with a blank row in between. The blank rows are filled with the following formula =IFERROR(INDEX(Bookings!$C$2:$C$200,MATCH(1,(Bookings!$A$2:$A$200<=A1)*(Bookings!$B$2:$B$200>=A1),0)),"")
In the Bookings worksheet I have something like this
1/1/18 8/1/18 John
8/1/18 15/1/18 Jim
15/1/18 22/1/18 Jill
My problem is with the 8/1/18 and 15/1/18 in that I really need to see John/Jim for the 8th and Jim/Jill for the 15th. At present I only get John for the 8th and Jim for the 15th.
If anyone had any suggestions how I might achieve this, I would be very grateful!