Forum Discussion
Fill Excel Calendar from a List
With Excel 365 you can use FILTER()
Lets say you have the cell A1 has the day number in it and a few lines below it for 'events' to be typed then in A2 type:
Assuming you Format as Table the Event list (name the table EVENTS)
=FILTER( EVENTS[Event], EVENTS[Day of Month]=DAY(A1), "")
(if you don't format the event list as table replace EVENTS[Event] with the range of event names and EVENTS[Day of Month] with range of event days, BUT I highly recommend you do format it as a table)this assumes the days in the template are actual DATE if they are NOT actual date values then replace DAY(A1) with just A1
With Excel 365 you can use FILTER()
Lets say you have the cell A1 has the day number in it and a few lines below it for 'events' to be typed then in A2 type:
Assuming you Format as Table the Event list (name the table EVENTS)
=FILTER( EVENTS[Event], EVENTS[Day of Month]=DAY(A1), "")
(if you don't format the event list as table replace EVENTS[Event] with the range of event names and EVENTS[Day of Month] with range of event days, BUT I highly recommend you do format it as a table)
this assumes the days in the template are actual DATE if they are NOT actual date values then replace DAY(A1) with just A1
- which template? can you share your workbook (no confidential/personal/private info)?
mtarler Here is some generic data & the calendar we are trying to use. We're aware that the calendar only has one row per day - I'll be adding rows once we figure out the fill issue. If we need to use a different one that would be fine, we'd just like the ability to switch the month and have the events autofill into the new month.
We're doing it this way because we need a clear visual representation of the events. We'll eventually have to add conditional formatting for a third set of data (less than or greater than highlighting for #'s associated with each event). Your formula worked in a separate sheet, just not with this calendar due to the formulas/array.