Hi I have created an events calendar as attached. I need assistance whereby I am unable to see bookings that are done on the same day as shown on sheet2. The earlier record indicated on the table is the entry i can see on the calendar. Is there a way where by I can see entries on the same date?
This proposed solution makes a couple of changes to sheet 3 then populates the table with the array entered formula*:Formula:
Please Login or Register to view this content.
*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks