Forum Discussion
How to populate a calendar with existing dates
Hi everyone,
I manage training programs for my company and I'm trying to figure out how I can populate an annual calendar with existing dates of training courses. I'd need this calendar to be dynamic so that it updates as I modify the dates. I'm not able to attached a sample file here and also not able to share an one drive link as I'm using my company's laptop. But below is the calendar I selected and trying to populate with the following dates
| Event Title | Start Date | End Date |
| Event 1 | 1/24/2023 | 1/26/2023 |
| Event 2 | 10/26/2022 | 10/27/2022 |
| Event 3 | 7/17/2023 | 7/21/2023 |
| Event 4 | 1/24/2023 | 1/24/2023 |
| Event 5 | 9/12/2022 | 12/15/2023 |
| Event 6 | 6/12/2023 | 6/16/2023 |
| Event 7 | 10/16/2023 | 10/20/2023 |
| Event 8 | 5/4/2023 | 5/9/2023 |
| Event 9 | 6/1/2023 | 6/2/2023 |
| Event 10 | 8/10/2023 | 8/12/2023 |
Calendar: https://templates.office.com/en-us/academic-calendar-tm02897376
Any help would be much appreciated!!
- The issue I have with the template in automating the events are the breaks in the data. The way the template is laid out, at minimum 12 formulas would need to be placed in the sheet to make this run.
I think a better approach might be to create a formula that generates the entire calendar and pulls the events all in one motion - 1 formula. Do you happen to know the version of Excel you're using? If you're on 365, the detail needed is the update channel found in File | Account | About Excel.
