Forum Discussion

dnrk5432's avatar
dnrk5432
Copper Contributor
Jan 22, 2024

Creating a monthy schedule that autopopulates from a task list

I have a list of events, with tasks under each one and due dates. 

 

I want to create a formula that searches all the events, and puts each task in the corresponding month it needs to be completed. The end goal is I can see each month, the task to do, the deadline, and which event it goes to. 

 

Also I have Excel 2019, so I do not have some of the newer functions. 

 

Attached is an example file. I have manually entered one of the events, but I want a function that could do it for me. In my real spreadsheet, I have a ton of tasks... very overwhelming! 

Help is appreciated. Thanks 🙂

 

 

Resources