I would be very grateful if anyone could help me with this problem.
I have two worksheets - one containing information about bookings for our holiday let - Column A is the date they arrive, column B is the date they depart and column E is their name. This sheet is named "Bookings". The second sheet is named "Calendar" and brings foward the details from "Bookings". The formula I use (which someone from this forum kindly helped me with) is =IFERROR(INDEX(Bookings!$E$2:$E$500,MATCH(1,(Bookings!$A$2:$A$500<=A420)*(Bookings!$B$2:$B$500>=A420),0)),""). A420 contains a date of 1/1/2021. The formula has worked perfectly - any bookings added to the "Bookings" sheet have come over to the "Calendar". However, none of the details from 1/1/2021 show on "Calendar". I have checked and rechecked the date format and it is the same that I used in 2020. I can't understand why a new year would make a difference. Would anyone have any idea why this formula isn't working for next year's bookings?
I hope I have given enough details and thank you in advance of any suggestions.
I have two worksheets - one containing information about bookings for our holiday let - Column A is the date they arrive, column B is the date they depart and column E is their name. This sheet is named "Bookings". The second sheet is named "Calendar" and brings foward the details from "Bookings". The formula I use (which someone from this forum kindly helped me with) is =IFERROR(INDEX(Bookings!$E$2:$E$500,MATCH(1,(Bookings!$A$2:$A$500<=A420)*(Bookings!$B$2:$B$500>=A420),0)),""). A420 contains a date of 1/1/2021. The formula has worked perfectly - any bookings added to the "Bookings" sheet have come over to the "Calendar". However, none of the details from 1/1/2021 show on "Calendar". I have checked and rechecked the date format and it is the same that I used in 2020. I can't understand why a new year would make a difference. Would anyone have any idea why this formula isn't working for next year's bookings?
I hope I have given enough details and thank you in advance of any suggestions.