Home

Calendar - returning a list based on date

b2boop
Occasional Visitor

I have expanded on a MS Excel template "Academic Calendar".  I have two parts:

LIST: of events (Table format Date -> Events);

Calendar (Monthly) which can change based on year and month view.  The dates are based on a formula.

I have named my table and first columns as a named reference in Excel.  Based on the formula found using arrays, I am not returning multiple values as expected.

See attached example excel document with 2 sheets.

Highlighted are the examples that I'm trying to create (that is two listings for the 22nd Nov 2018).  If I use a vlookup formula, I return a single value to the calendar, however, I would like tor return up to 4 events in a calendar day, hence the use of index arrays.  

Appreciate some expert advice.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies