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
Is there a way to see the full 12 month calendar view instead of one month at a time?
How do you format the event list for all 12 months instead of 1 month? For example I could list all the events needed throughout the year in one list so that they automatically populate on the calendar view?
@-needhelp what you want sounds very different that what this thread wanted. Maybe create a new thread with your actual question and needs. I would also suggest searching for excel templates for something close to what you want to help you a) explain what you want and b) give the volunteers here something to start from.
EDIT - nevermind the first part, I see you did create a new post. As for the second part, it would help if you found a year calendar that is close to what you want and what you mean/want/need in terms of repeating vs non-repeating events....