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 dyn...
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.
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.
